Solved Formula for Google Docs Sum of same cell in multiple sheets

November 6, 2015 at 15:18:04
Specs: Windows 7
I built in excel and uploaded to google docs a spreadsheet that contains very simple formulas to bring to sumation variables from multiple worksheet from the same cell, example:
=SUM(FW:MC!G10) (in Excel)
when uploaded it converts to:
=SUM([1]FW:MC!G10) and does not work.

What can I do to correct this so that I can calculate?


See More: Formula for Google Docs Sum of same cell in multiple sheets

Report •


#1
November 6, 2015 at 16:09:37
✔ Best Answer
I don't use Google Docs, but according to this 2011 thread, Google Docs does not allow 3D references. As far as I can tell, you will need to create a SUM formula referencing each individual sheet either before you upload the file or once it's in Google Docs.

https://productforums.google.com/fo...

In addition, while researching this, I found a couple of other threads that mention people having problems with even simple formulas changing when Excel workbooks are uploaded to Google Docs. Just be aware.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question