Try these:

=COUNTIF(K:K,"red apple")

=COUNTIF(K:K,"blue apple")


--
Biff
Microsoft Excel MVP


"mugwump" wrote in message
...
I have only two different text throughout column "K" say.. red apple or
blue
apple and I need to find out how many red apples and then how many blue.
Is
there a formula for this?