worksheet to worksheet subtotals

[bernieb]

I can't seem to figure out how to carry subtotals from a specific cell in
each worksheet over to a grandtotal cell on the last worksheet. ie. cell O33
on worksheet1 + cell O28 on worksheet3 + cell O53 on worksheet 4 and so on.
Any suggestions?

 

[Tyro]

One way is: Grand Total Cell has the formula:
=sheet1!O33+sheet3!O28+sheet4!O53 (etc).
tyro

 

[bernieb]

Tyro...thanks...one more question, do I use the terms "sheet1",
"sheet2"..etc, or the actual name of the worksheet?

 

[Mike Rogers]

bernieb

By all means use your sheet names. =Mysheet1!033+Mysheet2!028...

Mike Rogers

 

[David Biddulph]

But if your sheet names have spaces it'll need single quotes
='My sheet 1'!O33+'My sheet 2'!O28...

If you follow the routine I gave in reply to your repeat posting, it'll do
it automatically.