yogi_Pull From Data In Another Sheet Row By Row Sum Of Entities And Total At The Bottom

Google Spreadsheet   Post  #2199

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-04-2017

question by SATH59:

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

Help on a Query

Hi

In this sample doc:

https://docs.google.com/spreadsheets/d/1uYl7A8SSZnygbr1DFAW29U0R2P_umaiSRvwKku5tYHE/edit?usp=sharing

How can i achieve correctly the query im tryng to do ?

I have a tab named query where i explain better my Expected result for better understanding

Also need a total row below my query

Thanks !

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 !