worksheet to worksheet subtotals
 

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?

worksheet to worksheet subtotals
 

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

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

worksheet to worksheet subtotals
 

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

"Tyro" wrote:

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

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

worksheet to worksheet subtotals
 

bernieb

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

Mike Rogers


"bernieb" wrote:

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

"Tyro" wrote:

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

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

worksheet to worksheet subtotals
 

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.
--
David Biddulph

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
bernieb

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

Mike Rogers


"bernieb" wrote:

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

"Tyro" wrote:

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

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