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     www.energyefficientbuild.com.    Apr 12, 2013
user HowardRaab :(http://productforums.google.com/forum/?zx=k43irhucp48p#!searchin/docs/HowardRabb/docs/Ifjj9Xkr6IE/Ffz6e8HvFy8J)
sumproduct formulas working in excel but not in Google Docs
Hey,

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