Hi Gord

Typo alert
Where A1 is total cell on each sheet.
to match with your formula, it should be where A10 is the total cell on
each sheet.

Hope all is well with you.
--
Regards
Roger Govier

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Assuming the 31 sheets have their totals in same cell.

In Sheet32 in a cell enter =SUM(Sheet1:Sheet31!A10)

Where A1 is total cell on each sheet.


Gord Dibben MS Excel MVP


On Wed, 27 May 2009 19:11:01 -0700, adbolak
wrote:

I need a 31 day workbook with the 32 worksheet as a monthly. I need to
add
totals for all 31 on the 32 sheet for the monthly totals. I hope this
makes
sense.