COUNTA or COUNTIF or COUNT

[Liz]

Trying to count the times "YES" occurs in column C3:C5 for each time "Bill"
indicated in column B3:B5?

 

[Luke M]

=SUMPRODUCT(--(C3:C5="YES"),--(B3:B5="Bill"))

 

[Don Guillett]

=sumproduct((b3:b5="bill")*(c3:c5="yes"))

 

[Steve]

Try
=COUNTIFS(C3:C5,"YES",B3:B5,"Bill")

Regards
Steve

 

[Don Guillett]

xl2007