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