COUNTIF with 2 columns

[J.A.1975]

Hi, how do I count cells in A with nothing in B.

A B
x
x 2011/02/17
2011/03/21
x
x 2011/04/11
x

=COUNTIF(A:A;"x") but not counting when date (B:B) is available (it
means it did arrive)

Best regards,
Alberto

 

[joeu2004]

Hi, how do I count cells in A with nothing in B. [....]
=COUNTIF(A:A;"x") but not counting when date (B:B) is
available (it means it did arrive)

=SUMPRODUCT((A1:A100="x")*(ISNUMBER(B1:B100)=FALSE))

 

[J.A.1975]

Hi, how do I count cells in A with nothing in B. [....]
=COUNTIF(A:A;"x") but not counting when date (B:B) is
available (it means it did arrive)

=SUMPRODUCT((A1:A100="x")*(ISNUMBER(B1:B100)=FALSE))

Gracias joeu2004