How to count the number of cells in a column which do not contain a certain
And on the off chance the OP wants case-sensitive matching, the array
Funny thing with Excel 2003, using =countif(A1:A14,"Apple"), just does not 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?
Apple <> Apples
MS Excel MVP