Sunday, March 8, 2015

yogi_WorkAround For Implementing ArrayFormulation Using SUMIFS Function In Google Spreadsheet


                                           Google Spreadsheet   Post  #1915
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 08, 2012
post by SaggitariusAD, question by ANTONINO:
https://productforums.google.com/forum/#!mydiscussions/docs/FKpGJj2ma_4
Sum multiple cells from Sheet 1 to a single cell in Sheet 2 depending on criteria?
Hi, 
I have a little problem that I can not solve.
in particular, I can not get to work with the array formula sumifs.

here's my example::


I hope that you will fail
thank you
--------------------------------------------------------------------------------------------------------