Hi
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
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