Sum totals of 55 worksheets on Sheet 55?
 

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.

Sum totals of 55 worksheets on Sheet 55?
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"L. S. Martin" wrote in message ...
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.

Sum totals of 55 worksheets on Sheet 55?
 

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" wrote:

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.

Sum totals of 55 worksheets on Sheet 55?
 

Thanks to Both!

"Toppers" wrote in message
...
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" wrote:

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.