Home/ Questions/Q 11262
Next
Answered
computing
  • 7
Asked: 2021-12-08T01:30:04+00:00 In:

Solved Formula For Google Docs Sum Of Same Cell In Multiple Sheets

  • 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?

Share

    1 Answer

    1. 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.

      • 0