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