User Profile
MB-954
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
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?1.3KViews0likes0Comments
Recent Blog Articles
No content to show