How do I do the following? :


A B C


1 Q1 Yes
2 Q2 Yes
3 Q3 No
4 Q1 Yes
5 Q1 Yes

How can I code, Count the no. of times cell A1:A5 have "Q1" in it with
"Yes" in the respective "C" cell?
(In this eg. Q1 and Yes exist together 3 times)