How to make a formula to to count a word if 2 other cells have a value/text.

[Paul365]

Hello,

I have bens truggling to figure this out, if someone could help me it would be greatly appriciated.

I am trying to create a formula which will ocunt how many "yes" is in a range of cells if 2 different cells match.

example:
If bz12 cell matches bw7 Cell (Names of people) and ca12 cell has "$$" written in it, then I want it to count how many "yes" in a range of cells (let's say bz14 to bz18).

 

[Cubist]

Try:

=IF(AND($B$Z12=BW7,$CA$12="$$"),COUNTIFS($BZ$14:$BZ$18,"YES"),"")