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
https://docs.google.com/
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
No comments:
Post a Comment