Still not working

  • Thread starter Thread starter Jerry R
  • Start date Start date
J

Jerry R

I am trying to tally the life time hours of a piece of equipment taht the
hour meter has quiy working on. I know the hours on it when new meter was
installed. What I want is to have the total hours displayed in the same cell
for referance. The problem is everyday the formula needs to change. Example
day one the formula would be (A1+4000), the next day (a2+4000) and so on.
I guess what I want to know is there a formula that will take the last
cell in a colum that has data in it and add 4000 to it ?
 
Hi,

Provided the last cell in the range is a number this will do that

=LOOKUP(2,1/(A1:A20<>""),A1:A20)+4000

Alter a1:a20 to be larger than the likely maximum range

Mike
 
Another one...

=LOOKUP(1E100,A:A)+4000

That will "find" the *last* numeric entry in column A and add 4000.
 
Back
Top