View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Katintn Katintn is offline
external usenet poster
 
Posts: 3
Default 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