Count problems

[Sqdncall]

I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
the corresponding B1:B100 cell. Is this possible?

Thank you in advance

 

[Mike H]

Hi,

=SUMPRODUCT((A1:A100="A")*(B1:B100=""))

Mike

 

[Sqdncall]

Thank you Mike ! Works great!
--
Sqdncall

Hi,

=SUMPRODUCT((A1:A100="A")*(B1:B100=""))

Mike

 

[Shane Devenshire]

Hi,

If you are using 2007:

=COUNTIFS(A1:A100,"A",B1:B100,"")

 

[Shane Devenshire]

Hi,

In 2003 or 2007 you can also use this

=SUMPRODUCT(--(A1:A8&B1:B8="A"))