Counting cells that don't contain certain text
 

Is there a quick and easy way of counting the number of cells that don't
contain certain text strings

For example

Column A

Yes
No
Yes
Maybe
Maybe
No
Certainly
Definately
Yes

How could I count the number of cells that don't contain the word "yes" - in
this case the answer would be 6

Many thanks

Counting cells that don't contain certain text
 

See if this does the trick.

=COUNTA(A1:A9)-COUNTIF(A1:A9,"Yes")

"JRD" wrote:

Is there a quick and easy way of counting the number of cells that don't
contain certain text strings

For example

Column A

Yes
No
Yes
Maybe
Maybe
No
Certainly
Definately
Yes

How could I count the number of cells that don't contain the word "yes" - in
this case the answer would be 6

Many thanks

Counting cells that don't contain certain text
 

Hi!

Try this:

=COUNTIF(A1:A9,"<yes")

That will include empty and blank cells.

If you want to exclude empty/blank cells:

=SUMPRODUCT(--(A1:A9<""),--(A1:A9<"yes"))

Biff

"JRD" wrote in message
...
Is there a quick and easy way of counting the number of cells that don't
contain certain text strings

For example

Column A

Yes
No
Yes
Maybe
Maybe
No
Certainly
Definately
Yes

How could I count the number of cells that don't contain the word "yes" -
in
this case the answer would be 6

Many thanks

Counting cells that don't contain certain text
 

or if all cells are filled and j9 is the last cell with data
=COUNTIF(J1:J9,"<yes")

--
Don Guillett
SalesAid Software

"JRD" wrote in message
...
Is there a quick and easy way of counting the number of cells that don't
contain certain text strings

For example

Column A

Yes
No
Yes
Maybe
Maybe
No
Certainly
Definately
Yes

How could I count the number of cells that don't contain the word "yes" -
in
this case the answer would be 6

Many thanks

Counting cells that don't contain certain text
 

Try...

=COUNTIF(A2:A10,"?*")-COUNTIF(A2:A10,"Yes")

Hope this helps!

In article ,
JRD wrote:

Is there a quick and easy way of counting the number of cells that don't
contain certain text strings

For example

Column A

Yes
No
Yes
Maybe
Maybe
No
Certainly
Definately
Yes

How could I count the number of cells that don't contain the word "yes" - in
this case the answer would be 6

Many thanks