admiral100
Well-known Member
- Joined
- Jan 17, 2015
- Messages
- 873
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
<colgroup><col width="70" span="3" style="width:52pt"> </colgroup><tbody>
</tbody>
Thanks
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