Sum totals of 55 worksheets on Sheet 55?

[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.

 

[Ron de Bruin]

See this page for a example
http://www.rondebruin.nl/linksum.htm

 

[Guest]

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. S. Martin]

Thanks to Both!

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)