Thread
:
Referencing Cells in a Summary page
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Julleanna
external usenet poster
Posts: 4
Referencing Cells in a Summary page
IM (messanger) me at
. At the bottom of a new workbook you
have "sheet 1" "sheet 2" and "sheet 3". Sheet 1 is your summary page. Sheet 2
and sheet 3 are the ones that will have your running totals.
--
Julleanna
"Katintn" wrote:
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
Reply With Quote
Julleanna
View Public Profile
Find all posts by Julleanna