View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. S. Martin L. S. Martin is offline
external usenet poster
 
Posts: 2
Default 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.