thebigtable
asked on
Summerizing several worksheets
I would like to summerize several cells from several worksheets. All the cell are in the exact same location. I need the totals for all on the summary page.
Cheers,
Jody
Cheers,
Jody
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For example, if you have a Summary sheet and three additional sheets whose totals that you want to summarize are all in cell B10 of each individual sheet, you can use the following formula:
=SUM('first sheetname:last sheetname'!B10)
Of course, you replace first sheetname with the actual name of the first worksheet and likewise for the last sheetname.
If any of your sheet names have spaces in them, you MUST enclose all sheet references with single quotes (apostrophes).
See the attached example workbook for additional reference.
-Glenn
EE-3D-referencing.xlsx