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.