Sum totals of 55 worksheets on Sheet 55?

L

L. S. Martin

Have 55 worksheets in a work book, each has a total in cell L34. Right now,
am going to a cell on sheet 55, hit =, then go back to each page and click
on its total, hit +, then go to the next page --- all the way to page 55.
Plus, it won't let me even do 55 - have to do twice and add together.
Hoping there's a simple formula that will do the work?

Thanks for any help.
 
T

Toppers

You don't say how the sheets are named but a generic solution is:

Put w/sheet named "Start" before your first sheet to be summed and one
called "End" after the last w/sheet.

to sum:

=SUM('Start:End'!L34)
 
L

L. S. Martin

Thanks to Both!

Toppers said:
You don't say how the sheets are named but a generic solution is:

Put w/sheet named "Start" before your first sheet to be summed and one
called "End" after the last w/sheet.

to sum:

=SUM('Start:End'!L34)
Click to expand...
 
Top