Excel and several workpages

R

Rose

I forget how to tell my last workpage in a workbook to total all of the
previous pages. Would you please tell me the proceedure?

Thanks.
 
D

David McRitchie

hi Rose,

You can look up 3D references in Help or in Google, but basically
if you have sheet1 through sheet12 and you have sheet13 for your totals

C4 in sheet13: =SUM(sheet1:sheet12'!C4)
and it will sum C4 from all sheets physically between sheet1 and Sheet12 inclusively
just as you see them on your sheet tabs.

SUM doesn't care if the cell is blank so you could empty sheets at both ends
sheet13 cell C4:
=SUM('left place holder':'right place holder'!C4)
 
Top