"Jarek Kujawa" wrote in message
...
=MIN(IF(A1:A100="",ROW(A1:A100),""))

array-enter it = CTRL+SHIFT+ENTER

Many thanks,

V

Hi,
or a non-array alternative:
=SUMPRODUCT(--(A1:A0100="")*ROW(A1:A100))-1
By the way, Jarek's formula also needs a minus one (-1) to give a correct
client count, since it counts the blank row, as mine does.
Regards - Dave.

"Victor Delta" wrote:

"Jarek Kujawa" wrote in message
...
=MIN(IF(A1:A100="",ROW(A1:A100),""))

array-enter it = CTRL+SHIFT+ENTER

Many thanks,

V

"Dave" wrote in message
...
Hi,
or a non-array alternative:
=SUMPRODUCT(--(A1:A0100="")*ROW(A1:A100))-1
By the way, Jarek's formula also needs a minus one (-1) to give a correct
client count, since it counts the blank row, as mine does.
Regards - Dave.

Thanks. I'm actually using -2 to allow for the header row as well.

V

Hi Victor,
My formula doesn't work at all! Don't know what I was thinking. Sorry.
It sums all the blank cells in the range, not just the first one.
Dave.