Hi Mel,
Maybe something like this, where the last value in column A is added to the
value in B1 and where 9^9 is a very large number and greater than any you
would have in column A. If you knew that you would never have a number
larger than say 500, you could replace 9^9 with 500.

=LOOKUP(9^9,A:A)+B1

HTH
Regards,
Howard

"Mel" wrote in message
...
I'm entering data everyday and want to use the newest data with out
changing
the fromula everyday