Linking Time Sensitive Data

P

Perry W.

Hi. I have a spreadsheet with three pages. On each page there is a
cell with income for the day. Of course this changes every day. Each
page represents a different person.

On the main page I want to add up what everyone made so I can see at a
glance the total income for the day.

I'm sure I have to incorporate the date somehow, but I have no idea
how to begin.

Thanks for any help.

Perry
 
R

RagDyer

You don't need the date if the *same* cell on each page is used for the
daily total, and this same cell is overwritten each day.

Say the "Total" cell on each sheet is D25, in the MAIN page's "Total" cell,
you can enter this formula, which will return the total sum of the three
sheets:

=SUM(Sheet1:Sheet3!D25)

If however, the daily sheet total is *retained*, and a *different* cell is
used each day on the daily sheets, it would be good planning to have these
dailies in the same column, under one another, so that this total formula on
the Main sheet could just be copied down to return the entire time period's
totals, where *then* the appropriate date could be entered in an adjoining
cell to the total formulas.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi. I have a spreadsheet with three pages. On each page there is a
cell with income for the day. Of course this changes every day. Each
page represents a different person.

On the main page I want to add up what everyone made so I can see at a
glance the total income for the day.

I'm sure I have to incorporate the date somehow, but I have no idea
how to begin.

Thanks for any help.

Perry
 
P

Perry W.

You don't need the date if the *same* cell on each page is used for the
daily total, and this same cell is overwritten each day.
Click to expand...

Hi. No, the same cell is not used on each page, and it is not
overwritten every day. Thanks for the help.

Perry
 
Top