On Apr 11, 2:28*pm, "J.A.1975" wrote:
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 ))