Countif does not equal

J

JRD

How to count the number of cells in a column which do not contain a certain
text string?
 
H

Harlan Grove

Alan Beban said:
More responsively,

=COUNTIF(A1:A100,"<>*apple*")
Click to expand...

And on the off chance the OP wants case-sensitive matching, the array
formula

=COUNT(FIND("apple",range))
 
T

TJ Singh

Funny thing with Excel 2003, using =countif(A1:A14,"Apple"), just doesn't seem to count at times,but changing it to "Apples" gets you a count? Is it a bug or is it about Microsoft and Apple?
 
B

Bernie Deitrick

Apple <> Apples

Try

=countif(A1:A14,"Apple*")
or
=countif(A1:A14,"*Apple*")

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using <= in countifs statement 1
countifs Function not giving desired result with date criteria 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Excel 2010 countifs for date range 3
Countif or other formula needed for multiple data/critera results 3
using CountIF function or Array? 3
Excel does not accept text format! 0
Excel Countif Function - Calculating Between Two Sets of Values 3

Top