multiple conditional counts

[N. Halvin]

I am trying to do a conditional count...but with several
conditionals involving two columns. Does anyone know how
to do this?

Example:

A B
MD yes
CK yes
MD yes
DW no
MD no
CK yes
CK no
What I want to know is: count how many of value "MD" in
column A, when value in B is "yes". Can anyone help?

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A100="MD")*(B1:B100="yes"))

 

[Ken Wright]

=SUMPRODUCT((RngA="MD")*(RngB="yes"))

or

=SUMPRODUCT(--(RngA="MD"),--(RngB="yes"))