Sunday, December 25, 2016

yogi_WorkAround For An ArrayFormula Application Where Normally SUMIFs Function Would be Used

Google Spreadsheet   Post  #2098
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-25-2016
How to convert a SUMIF to ARRAYFORMULA

I have this formula in Cell A2

=SUMIFS(E$2:E,A$2:A,A2,C$2:C,C2,E$2:E,">0")-SUMIFS(F$2:F,A$2:A,A2,C$2:C,C2,F$2:F,">0")

In cell A3
=SUMIFS(E$2:E,A$2:A,A3,C$2:C,C2,E$2:E,">0")-SUMIFS(F$2:F,A$2:A,A3,C$2:C,C2,F$2:F,">0")

And goes down just changes the "A2" to "A3" and so on for all my rows

How can I convert it to an array, so I don't have to copy down the formula every time I add a new column ?

Thanks !