counta

Graham · May 22, 2009

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

Thanks
gees

Jacob Skaria · May 22, 2009

=SUMPRODUCT(--(A1:A40<>""),--(B1:B40>0))

Graham · May 22, 2009

Thanks Jacob for such a quicke response...ammazing how technology works!
Formulae works great.