Try...

=COUNTBLANK(INDEX(A2:A10,MATCH(BigNum,A2:A10)+1):A 10)

....where BigNum is defined as 9.99999999999999E+307.

Hope this helps!

In article ,
geoff1234
wrote:

Hi again,

I've got a list like this:

45
32
23
blank
34
45
blank
blank
blank

any idea how to count the number of blanks after the final non-blank
cell?