Excel: Sum the same name (for a calculated total) on multiple sheet tabs

Copper Contributor

Workbook contains multiple sheets, with common/sequential sheet names containing common data, (not identical, not same location or format due to differences in equipment sizes / models) with the same name present on each sheet: Sheet1!WXYZ_20....Sheet24!WXYZ_20.


Cannot use 3D reference due to totals not being in identical cell locations of the sheets.  Seems like this should work: Sum(Sheet1:Sheetn!WXYZ_20) ...... but it does not, even between two adjacent sheets with valid names/values.  Seems like a perfect use of names across sheets, but I'm missing the ability to use the Sum function......... I find on-line references to the use of Cells being able to be summed across sheets, but not Names.  



0 Replies