Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
Hello to all who can help me with this. I've already tried the online
directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
One way:
=SUM(Sheet1:Sheet3!A1) In article , ABG wrote: Hello to all who can help me with this. I've already tried the online directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
where do i put that on the 4th page i'm wanting it to reference to? i need
it to be set up the same way. "JE McGimpsey" wrote: One way: =SUM(Sheet1:Sheet3!A1) In article , ABG wrote: Hello to all who can help me with this. I've already tried the online directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
also, error comes up something about a circular group?....ahhhh....
"JE McGimpsey" wrote: One way: =SUM(Sheet1:Sheet3!A1) In article , ABG wrote: Hello to all who can help me with this. I've already tried the online directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
I like to make a "sandwich" out of my worksheets.
I'd insert two worksheets--one to the far left called "Start" and one to the far right named "End". Then I could use a formula like: =sum('start:end'!N2) to add up all the worksheets that are between those two "pieces of bread". The cell with the formula would go in a worksheet that's not inside the sandwich. ABG wrote: Hello to all who can help me with this. I've already tried the online directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
like your analogy...ok so if the end of the sandwich i have my "plate" to put
it on where to i put the =sum.... "Dave Peterson" wrote: I like to make a "sandwich" out of my worksheets. I'd insert two worksheets--one to the far left called "Start" and one to the far right named "End". Then I could use a formula like: =sum('start:end'!N2) to add up all the worksheets that are between those two "pieces of bread". The cell with the formula would go in a worksheet that's not inside the sandwich. ABG wrote: Hello to all who can help me with this. I've already tried the online directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, -- Dave Peterson |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
i must be slow at excel...but i've been trying to do this and keep getting
these weird errors. helppppp............ughhhhhhhhhhhhhhhhh.....frustr ation.... "Dave Peterson" wrote: I like to make a "sandwich" out of my worksheets. I'd insert two worksheets--one to the far left called "Start" and one to the far right named "End". Then I could use a formula like: =sum('start:end'!N2) to add up all the worksheets that are between those two "pieces of bread". The cell with the formula would go in a worksheet that's not inside the sandwich. ABG wrote: Hello to all who can help me with this. I've already tried the online directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, -- Dave Peterson |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
Do not put your plate worksheet (the worksheet that contains the cell with the
formula) inside the sandwich. Put it to the far right or to the far left. ABG wrote: like your analogy...ok so if the end of the sandwich i have my "plate" to put it on where to i put the =sum.... "Dave Peterson" wrote: I like to make a "sandwich" out of my worksheets. I'd insert two worksheets--one to the far left called "Start" and one to the far right named "End". Then I could use a formula like: =sum('start:end'!N2) to add up all the worksheets that are between those two "pieces of bread". The cell with the formula would go in a worksheet that's not inside the sandwich. ABG wrote: Hello to all who can help me with this. I've already tried the online directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
Take a look at this screencap:
http://img210.imageshack.us/img210/8144/sumgg1.jpg The formula is on the Summary sheet. The Summary sheet is outside of the "sandwich". Any sheets *within* the sandwich will be included in the sum. -- Biff Microsoft Excel MVP "ABG" wrote in message ... i must be slow at excel...but i've been trying to do this and keep getting these weird errors. helppppp............ughhhhhhhhhhhhhhhhh.....frustr ation.... "Dave Peterson" wrote: I like to make a "sandwich" out of my worksheets. I'd insert two worksheets--one to the far left called "Start" and one to the far right named "End". Then I could use a formula like: =sum('start:end'!N2) to add up all the worksheets that are between those two "pieces of bread". The cell with the formula would go in a worksheet that's not inside the sandwich. ABG wrote: Hello to all who can help me with this. I've already tried the online directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, -- Dave Peterson |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D reference need help please
And just to add to Biff's response...
It's a neat way to play what-if games. You can drag any of those "meat" worksheets outside the sandwich and its data won't be included in the summary formulas. "T. Valko" wrote: Take a look at this screencap: http://img210.imageshack.us/img210/8144/sumgg1.jpg The formula is on the Summary sheet. The Summary sheet is outside of the "sandwich". Any sheets *within* the sandwich will be included in the sum. -- Biff Microsoft Excel MVP "ABG" wrote in message ... i must be slow at excel...but i've been trying to do this and keep getting these weird errors. helppppp............ughhhhhhhhhhhhhhhhh.....frustr ation.... "Dave Peterson" wrote: I like to make a "sandwich" out of my worksheets. I'd insert two worksheets--one to the far left called "Start" and one to the far right named "End". Then I could use a formula like: =sum('start:end'!N2) to add up all the worksheets that are between those two "pieces of bread". The cell with the formula would go in a worksheet that's not inside the sandwich. ABG wrote: Hello to all who can help me with this. I've already tried the online directions and it's still not working. Ex/ I have 3 worksheets and 1 final all within the same excel 2003 file. I am trying to get all the cells from worksheets 1,2,& 3 to add up and be placed in worksheet 4. I know that their is a way to do this but I must not be doing it correctly. Could someone please give me some insider direction I would appreciate it. Thanks, -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |