Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fomula when adding the same cell across multiple tabs
I know there is a way to add the same cell (say G3) across multiple tabs,
without simply Pointing to each cell on each tab. I cannot remember how. Help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fomula when adding the same cell across multiple tabs
Select all sheets where you want this to happen (hold down shift and click
the first and the last or hold down ctrl and click them one by one), it is important that when you are done that you ungroup them (right click any tab and select ungroup) or else you might create a mess. -- Regards, Peo Sjoblom "RAL" wrote in message ... I know there is a way to add the same cell (say G3) across multiple tabs, without simply Pointing to each cell on each tab. I cannot remember how. Help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fomula when adding the same cell across multiple tabs
The sheets have to be in sequential order:
=SUM(Sheet1:Sheet10!G3) Or, you can create a sheet sandwich where the order doesn't matter. Insert an empty sheet named Start to the immediate left of the first sheet you want to include in the formula. Insert another empty sheet named End to the immediate right of the last sheet you want to include in the formula. Then: =SUM(Start:End!G3) Any sheet in the sandwich will be included in the formula. Biff "RAL" wrote in message ... I know there is a way to add the same cell (say G3) across multiple tabs, without simply Pointing to each cell on each tab. I cannot remember how. Help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fomula when adding the same cell across multiple tabs
Thanks - thats the one!
"T. Valko" wrote: The sheets have to be in sequential order: =SUM(Sheet1:Sheet10!G3) Or, you can create a sheet sandwich where the order doesn't matter. Insert an empty sheet named Start to the immediate left of the first sheet you want to include in the formula. Insert another empty sheet named End to the immediate right of the last sheet you want to include in the formula. Then: =SUM(Start:End!G3) Any sheet in the sandwich will be included in the formula. Biff "RAL" wrote in message ... I know there is a way to add the same cell (say G3) across multiple tabs, without simply Pointing to each cell on each tab. I cannot remember how. Help? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fomula when adding the same cell across multiple tabs
You're welcome. Thanks for the feedback!
Biff "RAL" wrote in message ... Thanks - thats the one! "T. Valko" wrote: The sheets have to be in sequential order: =SUM(Sheet1:Sheet10!G3) Or, you can create a sheet sandwich where the order doesn't matter. Insert an empty sheet named Start to the immediate left of the first sheet you want to include in the formula. Insert another empty sheet named End to the immediate right of the last sheet you want to include in the formula. Then: =SUM(Start:End!G3) Any sheet in the sandwich will be included in the formula. Biff "RAL" wrote in message ... I know there is a way to add the same cell (say G3) across multiple tabs, without simply Pointing to each cell on each tab. I cannot remember how. Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding multiple checkboxes in a single cell | New Users to Excel | |||
adding multiple checkboxes in a single cell | New Users to Excel | |||
Cell Fomula | Excel Worksheet Functions | |||
Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
How to get cell value with the ID from a fomula? | Excel Discussion (Misc queries) |