Summing function

[Sully38]

I have an excel workbook that contains 31 sheets ( 1 for each day of a month). These sheets contain the same cell values for each sheet.
Does Excel contain a function that would allow me to insert a total page and have it calculate the value in the cells across all the sheets?

 

[Smitty]

How about:

=SUM('1:31'!A1)

Where 1 is the first sheet and 31 the last. Excel will sum those sheets and all in between.

HTH,

Smitty

 

[bsnapool]

Smitty

Are you aware of a formulae to do this with weeks but sum them monthly?