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 ?

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A)) + 4000
--
HTH...

Jim Thomlinson


"Jerry R" wrote:

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

"Jerry R" wrote:

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 ?

Another one...

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

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

--
Biff
Microsoft Excel MVP


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

In the imortal words of Elvis, THANK YOU, THANK YOU VERY MUCH !!!!

"Mike H" wrote:

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

"Jerry R" wrote:

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 ?