Home > front end >  GoogleSheets SumIFS in array formula
GoogleSheets SumIFS in array formula

Time:03-20

I'm trying to convert my Sumifs formula into an array formula (so that the sheet auto updates)

I'm struggling to do so though

I tried using sumif formula and combining the columns, but I can't get it to work right.

I created this simplified version of my data

output

  • Related