Hi
the reason for this is that COUNTA counts the formula result "" also as
a non blank cell. Try the following instead to get the last numeric
value in your range:
=VLOOKUP(9.9999999E307,$X5:$X100)

--
Regards
Frank Kabel
Frankfurt, Germany

I have a spreadsheet that is updated on a weekly basis and I have a
summary of the information at the bottom of the page. I only want to
show the last figure in column X. I've been using the following
formula....

OFFSET($X$5,COUNTA($X5:$X56)-1,0)

This has worked until I put a formula in column X (the user used to
have to fill this in as they went). Now my OFFSET formula isn't
working. Is it because I now have an underlying formula there?

I have this formula in column X so the user only has to enter the
data
in column W and column X calculates for them.

IF(ISBLANK(W14),"",SUM(X13+W14))

Can anyone help??


---
Message posted from http://www.ExcelForum.com/