Hi all,

I am trying to find a formula that will count specific words within a range.
Some of the cells may be part of a text string for example:

count the word "red" within cells containing "red", "red 1", "red 2" etc.
I know this can be done with the formula...=countif(range, "*red*")

The real question is if I can do this by searching for a word within a cell
value? So, if cell "A1" equals "red", count "red", if cell "A1" equals
"blue", count blue.
Thanks in advance.

If I follow simply amend your formula

=countif(range, "*" & A1 & "*")

Regards,
Peter T

"JohnH" <(E-Mail Removed)> wrote in message
news:9532B661-6A04-4045-925E-(E-Mail Removed)...
> Hi all,
>
> I am trying to find a formula that will count specific words within a
> range.
> Some of the cells may be part of a text string for example:
>
> count the word "red" within cells containing "red", "red 1", "red 2" etc.
> I know this can be done with the formula...=countif(range, "*red*")
>
> The real question is if I can do this by searching for a word within a
> cell
> value? So, if cell "A1" equals "red", count "red", if cell "A1" equals
> "blue", count blue.
> Thanks in advance.
>