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    Jan 30, 2013
post by user: Smartgeek and question by Abdelkrim METRAB said:(!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.
Anyone can help me figure out this please?

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