Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create total from 4 seperate worksheets
I have a file that contains up to 5 sheets, I need to total a cell from each
sheet and enter into a colomn on last sheet. What formula do I use? Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create total from 4 seperate worksheets
You just have to reference the sheet and the cell in the sheet. See sample
formula below: =Sheet1!A1+Sheet2!A1+Sheet3!B1+Sheet4!A1 -- Kevin Backmann "Harvey" wrote: I have a file that contains up to 5 sheets, I need to total a cell from each sheet and enter into a colomn on last sheet. What formula do I use? Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
create total from 4 seperate worksheets
Are your totals always in the same cells in each worksheet. I like to put my
totals in Row 1--so I know where they are. And then... I'd create two new worksheets--one to the far right and one to the far left. Call them Start and End Then using a sheet (Summary) that is outside this "sandwich" of worksheets: =Sum(start:end!A1) Then you can drag sheets in and out of that sandwich to play what if games. I'd put a couple of notes on each of these sheets: "don't delete this sheet!" And protect the worksheets so that people don't use it for real data. Harvey wrote: I have a file that contains up to 5 sheets, I need to total a cell from each sheet and enter into a colomn on last sheet. What formula do I use? Is this possible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
create multiple worksheets in workbook from one csv file | Excel Discussion (Misc queries) | |||
how do I get a total for all worksheets in my workbook? | Excel Discussion (Misc queries) | |||
Create a custom footer for all Excel worksheets at one time... | Excel Discussion (Misc queries) |