MB-954
Aug 20, 2022Copper Contributor
Excel: Sum the same name (for a calculated total) on multiple sheet tabs
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.
Suggestions?