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
|