Hi everyone, I've got a situation I've been trying to figure out for a while and I absolutely can't. What I need to do is do a countif to look at 2 different rows and if they are the correct value, to add 1 to the countif.

To demonstrate:
1 Yes
1 No
5 Yes
3 Yes
1 Yes
5 No

In this example, I want to be able to count if 1 and Yes are on the same line (in this case it would be 2). I have a semi working formula at the moment but it is rather ugly, it involves creating a new column that concatenates the 2 rows together, then comparing one line (COUNTIF(X:X,1Yes)). If there is anyone way to do this I would really appreciate anyones input. Thanks in advance!