Hi,

Assuming that the weight data are in columns B (for example, B2-B9),
use the following formula:

=$B$2-INDEX($B$2:$B$9,COUNT($B$2:$B$9))

If this post is helpful, please click "Yes".

Regards,
Ramachandran


"Jamie" wrote:

Excel 2003
I'm tracking weight loss.
In one column I have a list of #'s.
The top # is the beginning weight.
Each # under the beginning weight is from succesive weigh-ins.
I want a cell at the bottom of the column that displays the total weight loss.
How do you make the cell recognize the last weigh-in entry in stead of the
previous one?

Date Adam
2-Nov 202 <-----Starting Weight
6-Nov 196 <-----1st Weigh-in
10-Nov
13-Nov
17-Nov
20-Nov
24-Nov
25-Nov
Total Loss ??????<-----Calculate Total Loss?