Hi,

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

Mike

"Sqdncall" wrote:

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