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::

https://docs.google.com/spreadsheets/d/1CUZz5DiJOtsyU6vefgJrjH4_KyBssetVSA38o8zBnm8/edit#gid=330022702

I hope that you will fail

thank you

--------------------------------------------------------------------------------------------------------