COUNTIF with 2 columns

  • Thread starter Thread starter J.A.1975
  • Start date Start date
J

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
 
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))
 
Back
Top