That simple, eh?
Thanks a lot. That did the trick.

Jan


"Bob Phillips" skrev i melding
...
=COUNTIF(A:A,"*K*")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jan T." wrote in message
...
Hi.
I want to count all cells in a range that contains the letter K.

RON BLAIR KASPER HULK FRONT KIM

The example here would return 3 because 3 cells are containing a name
that
has K in it.
I think I should put functions like SUMPRODUCT AND ISNUMBER AND MATCH,
but how do I put theese together?

Thanks in advance.

Mvh
Jan