Another one...

=IF(COUNT(B2:B10),B2-LOOKUP(5000,B2:B10),0)

--
Biff
Microsoft Excel MVP


"Jamie" wrote in message
...
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?