=SUMPRODUCT(--(A1:A40<""),--(B1:B400))
--
If this post helps click Yes
---------------
Jacob Skaria


"Graham" wrote:

I have data in colunm A and would like to count how many there are (in A) if
column (B1:B40)0.

Thanks
gees