CountIf with two conditions

[montanaaggie]

In cell A1, I currently have the following equation
=countif(B1:B50,C1).

This equation lets me know if the value in column B is also located in column C. However, I don't want it to count it unless another parameter is met, let say column D, also has to display the word "YES".

How do I do go about doing this?

Thanks!

 

[Scott Huish]

Before XL2007:

=SUMPRODUCT(--(B1:B50=12),--(D1:D50="YES"))

XL2007 and higher:

=COUNTIFS(B1:B50,C1,D1:D50,"Yes")
If you need compatibility across versions, use the first one.