Friday, April 12, 2013

yogi_Using SUMPRODUCT Formula In Google Spreadsheet Based On Multiple Conditions And Data In Another Sheet

                                          Google Spreadsheet   Post  #1115
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 12, 2013
user HowardRaab :(!searchin/docs/HowardRabb/docs/Ifjj9Xkr6IE/Ffz6e8HvFy8J)
sumproduct formulas working in excel but not in Google Docs

I have created an excel sheet that uses sumproduct to pull information from one tab and bring it into the other.  This works perfectly into excel but when I got to upload it to Google Docs most of my cells become #num

Although some still work.

Can anyone see anything wrong with these formulas, or know why they would work fine in excel but be completely broken in Sheets?
SUMPRODUCT function in Google spreadsheet needs to be array enabled.
following is a solution to the problem