Hi all,

I am trying to count a word within a range of cells. Some cells may contain
the word within a text string for example:
Count the word "red" within "red 1", "red 2", "red 3" etc.
I know this can be done with the formula..."=CountIf(range, "*red*")"

The real question is if this is possible to search by a cell value?
ie. If cell "A1" equals "red" then count "red", if "A1" equals "blue" then
count the number of times "blue" appears.

Hope this makes sense. Thank you.

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

--
__________________________________
HTH

Bob

"JohnH" <(E-Mail Removed)> wrote in message
news:00B3512D-BEC9-41C1-BFF5-(E-Mail Removed)...
> Hi all,
>
> I am trying to count a word within a range of cells. Some cells may
> contain
> the word within a text string for example:
> Count the word "red" within "red 1", "red 2", "red 3" etc.
> I know this can be done with the formula..."=CountIf(range, "*red*")"
>
> The real question is if this is possible to search by a cell value?
> ie. If cell "A1" equals "red" then count "red", if "A1" equals "blue" then
> count the number of times "blue" appears.
>
> Hope this makes sense. Thank you.