Excel and several workpages
 

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.

Excel and several workpages
 

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)
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rose" wrote in message ...
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.