I'm wanting to add the value of B3 from each of 30 consecutive tabs, totaled on Tab 31. Is there a simple, shorthand way of expressing that, or do i have to add each one in a long string? Many thanks!
I'm wanting to add the value of B3 from each of 30 consecutive tabs, totaled on Tab 31. Is there a simple, shorthand way of expressing that, or do i have to add each one in a long string? Many thanks!
You can use something likeFormula:
=SUM(Sheet1:Sheet30!B3)
That was the first thing i tried, but it's not working, with our without parentheses around the sheet names.
In that case can you provide a sample workbook.
Attached is the book, thanks!
this
in B3
=SUM('1:31'!B3)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks for that.
It should beFormula:
=SUM('1:31'!B3)
That did it, thanks so much!
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks