I have two columns Q & V. In column Q the answer will be Y or N, the same for column V.

What I want to do is have a formula in one cell that counts when there is a Yes in both columns. Therefore if there are 20 Y's in column Q and 10 in column V. The result would be 10. As there are 10 Y's in both columns.

I have tried MATCH, various counts, so I am either using the wrong formula, or I am putting my brackets in the wrong place.

Please help.

Thanks

J