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

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

On 11 abr, 18:15, joeu2004 <joeu2...@hotmail.com> wrote:
> On Apr 11, 2:28*pm, "J.A.1975" <josealberto1...@gmail.com> 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