Apple < Apples

Try

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

HTH,
Bernie
MS Excel MVP


<TJ Singh wrote in message ...
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?