Having the following situation:

A B C
Yes No Yes
Yes Yes Yes
No No No

I am trying to count the number of rows that contain at least one time "Yes". In order to do so I have the following formula: =SUM(IF(FREQUENCY(IF(A1:C3="Yes";ROW(A1:C3))>0;1)) as an array.

Now this data is going to be filtered, so I need to move this into a subtotal formula, but I cannot seem to get this working. The results is never 2 in this example.

Help is greatly appriciated, because it took me the whole afternoon to end up with nothing