help with formula - basic total, but including a date function

[carol]

Hi,

I have a worksheet with information on money held by 20 different people. In
each sheet (1 per client), I have inputed valuations for each month.

In sheet 1, I want to see at a glace the latest valuation per client, but
this needs to be linked to the date, so that it generates the valuation
corresponding to the latest date.

Any ideas?

Thanks in advance.

 

[Gary''s Student]

For each person, put the latest data at the top of each person's worksheet,
not the bottom. Many beginners enter periodic data simply by adding a new
row at the bottom of the worksheet. If you insert new data at the top, you
will always know where the most recent data is.