J
JRD
How to count the number of cells in a column which do not contain a certain
text string?
text string?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=COUNTIF(A1:A100,"<>apple")
A
Alan Beban
Teethless said:=COUNTIF(A1:A100,"<>apple")
:
More responsively,
=COUNTIF(A1:A100,"<>*apple*")
Alan Beban
H
Harlan Grove
Alan Beban said:More responsively,
=COUNTIF(A1:A100,"<>*apple*")
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
Try
=countif(A1:A14,"Apple*")
or
=countif(A1:A14,"*Apple*")
HTH,
Bernie
MS Excel MVP