|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 6th, 2008, 10:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 
|
|
#2
January 6th, 2008, 10:57 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#3
January 7th, 2008, 01:03 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#4
January 7th, 2008, 01:17 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#5
January 7th, 2008, 09:55 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
