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.

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.

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.

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.