Use this instead:

=SUBTOTAL(102,B1:B6)

Excel Help on SUBTOTAL explains the meaning of the 102 (and other
numbers that can be used).

Hope this helps.

Pete

On Sep 23, 11:23*am, "Alain Dekker"
wrote:
Hi,

I set up a new workbook and put the values 1,2,3,4 into cells A1 to A4
respectively. Leave A5 and A6 blank. Now I put the formula "=count(B1:B6)"
into cell A7 and the values is 4 (ie. 4 non-blank cells).

All well and good.

Now I hide row 3. The value still stays 4. I know this is correct, but is
there another formula that just counts visible, non-blank cells?

Thanks,
Alain