Count Rows

[admiral100]

Hi,

I am looking for a formula or VBA that count only the rows containing the word Yes.
In this example the result should be 3 (row 1,3,4)

A B C

Yes	No	1 No
No	No	2 No
Yes	Yes	3 Yes
No	No	4 Yes

<colgroup><col width="70" span="3" style="width:52pt"> </colgroup><tbody>
</tbody>

Thanks

 

[admiral100]

maybe something like...

=SUM(IF(FREQUENCY(IF(A1:C4="yes",ROW(A1:A4)-ROW(A1)+1),ROW(A1:A4)-ROW(A1)+1),1)) control shift enter

Hi Weazel ,

Your formula works like a charm! thanks a lot.
I tried hours to resolve only by formula.... you did it.