COUNTIF with 2 columns
 

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

COUNTIF with 2 columns
 

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

COUNTIF with 2 columns
 

On 11 abr, 18:15, joeu2004 wrote:
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 ))

Gracias joeu2004