Sunday, July 21, 2013

yogi_Set Up A Totals Sheet Which Consolidates Data From Cells of Current And Future Sheets

                                          Google Spreadsheet   Post  #1299
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 21, 2013
user: Ashtine1 (http://productforums.google.com/forum/?zx=ypp2d4hsq8dw#!mydiscussions/docs/Wc75hAF8wK4)
How to create a range formula adding the value of the same cell on multiple sheets
Hello, I started creating a google sheets spreadsheet with many sheets. I want to create a range formula in the cell E8 of the first sheet named "TOTALS", that adds the value of the cell  G20 of all the other sheets. I dont want to put in each sheet name because that would make the string too long. Just create a range for the same cell from the first sheet to the last sheet. I know how to do it in Excel, I use:  =SUM('SCH001:SCH0050'!G20). SCH001:SCH0050 is the range from sheet one to sheet 50, and G20 is the cell with the data on every sheet, and i place this formula on the TOTALS sheet, cell E8. Works fine in Excel, However, the same formula wont work in google sheets. it will be great if someone can help me.
OS: Windows 7
Broweser: Google Chrome



Thanks Much,
Robert
------------------------------------------------------------------------------------------------------------------------------------------------------