Sample data:
R1: No, Yes, No
R2: Yes, Yes, Yes
R3: No, No, No

Are the Yes/No in separate cells or is No, Yes, No all in one cell?

--
Biff
Microsoft Excel MVP


"cooey" wrote in message
...
Hi.

Sample data:
R1: No, Yes, No
R2: Yes, Yes, Yes
R3: No, No, No

How do get a count of the rows that contain No?

So for the sample above, the output i'm looking for is 2 (2 rows
where No exists).

TIA!