Wednesday, January 30, 2013

yogi_Compute MultiConditional Sum Using Various Functions Such As SUMPRODUCT SUM FILTER And QUERY


                                          Google Spreadsheet   Post  #997
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 30, 2013
post by user: Smartgeek and question by Abdelkrim METRAB said:(http://productforums.google.com/forum/?zx=7oinkl81cee#!mydiscussions/docs/UA5o5zfXBdY)
sumproduct just doesn't work at all !!!
Hi guys,

I just can't get away from this endless error in using SUMPRODUCT formula. 
As you see I'm clear in putting the formula into the sheet, however it doesn't work.
I want to get the score of steve in July. FYI it works well in excel but google sheet.
=sumproduct((month(F23:F26)=7)*(E23:E26=E23)*(G23:G26)) 
Anyone can help me figure out this please?

------------------------------------------------------------------------------------------
following is a solution using various alternate functions such as SUM SUMPRODUCT FILTER and QUERY