| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Subtotals to new worksheet | Excel Worksheet Functions | |||
| subtotals value can be vlookup by another worksheet | Excel Discussion (Misc queries) | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| Copy Subtotals to another worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
