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
|