Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Cells in a Summary page
I am working on a budget spreadsheet, with multiple worksheets, I have a
Summary sheet in front and need to keep the Summary totals to be the running balance from each of the other worksheets... How do I formulate that to pickup each cell each time a running balance cell changes? THANKS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Cells in a Summary page
If you are totaling all worksheets to the Summary sheet this is the easiest
way to do this. Let's say on sheet 1 your total is in cell E10, sheet 2 total is E 12. On the Summary sheet click the cell where you want the total. Enter =sum( click on sheet 1 cell E10 put the + sign, than click sheet 2 cell E12 and so on. When you are done put the ) sign after the last cell than hit enter. Hope this helped. -- Julleanna "Katintn" wrote: I am working on a budget spreadsheet, with multiple worksheets, I have a Summary sheet in front and need to keep the Summary totals to be the running balance from each of the other worksheets... How do I formulate that to pickup each cell each time a running balance cell changes? THANKS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Cells in a Summary page
Thank for responding Julleanna.... What I have is 1st worksheet is all line
items of an operating budget with beginning budget balance, the following worksheets are 1 worksheet for each line items where subtractions/additions will be done throughtout the budget year... the running total column of each worksheet is what I'm looking to have referenced on the summary page. "Julleanna" wrote: If you are totaling all worksheets to the Summary sheet this is the easiest way to do this. Let's say on sheet 1 your total is in cell E10, sheet 2 total is E 12. On the Summary sheet click the cell where you want the total. Enter =sum( click on sheet 1 cell E10 put the + sign, than click sheet 2 cell E12 and so on. When you are done put the ) sign after the last cell than hit enter. Hope this helped. -- Julleanna "Katintn" wrote: I am working on a budget spreadsheet, with multiple worksheets, I have a Summary sheet in front and need to keep the Summary totals to be the running balance from each of the other worksheets... How do I formulate that to pickup each cell each time a running balance cell changes? THANKS |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Cells in a Summary page
First, you can use the 3D reference, if you go to EXCEL-HELP, and search for
3D Reference, it will give you a detailed instruction on how to enter the formula. Secondly, is a method I prefer, especially when the actual sheet names have meaning and will appear on the Summary sheet (i.e.: a list of the totals for each sheet followed by the overall total). For example, assume column A on summary sheet will have sheet name, and column B is where you want the desired data from each sheet to appear, cell E20 from all the other sheets is where you are pulling your data from. Col A. Col B. Row 2 Totals =sum(b3:b100) Row 3 Data1 =INDIRECT("'"&A3&"'!"&$E$20) Row 4 Data2 (You would edit fill down as needed etc. Note: The indirect formula has a single quote (apostraphe) in between the 2 double quotes at the beginning and another single quote just before the exclamation mark. The sheet name entered in column A, must, of course, match the actual sheet name exactly, including spaces. -- John C "Katintn" wrote: I am working on a budget spreadsheet, with multiple worksheets, I have a Summary sheet in front and need to keep the Summary totals to be the running balance from each of the other worksheets... How do I formulate that to pickup each cell each time a running balance cell changes? THANKS |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Cells in a Summary page
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing cells and copy rows of data back to summary sheet | Excel Discussion (Misc queries) | |||
Summary page | Excel Discussion (Misc queries) | |||
add cells from various pages in a summary page | Excel Discussion (Misc queries) | |||
Filling cells on a summary page | Excel Worksheet Functions | |||
Summary worksheet referencing multiple worksheets | Excel Worksheet Functions |