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

question by: SATH59:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/0vkWCc-IwFY;context-place=forum/docs

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 !