If 'Bent' is in K1,
=COUNTIF(F:F,K1)


"Walter" wrote in message
...
=COUNTIF(F:F,"Bent")
=COUNTIF(F:F,"Binding")
=COUNTIF(F:F,"Broken")

So I have these formulas that will count the occurences of words in column
F. The formula resides in column L. I need to replace the word inside
the
quotes with a new word or a new phrase based upon a list in column K. How
do
I go about doing that? I am assuming that the formula would involve
Search,
Replace, & some concatenation but I am not sure how to assemble it. I
have
been manually replacing a new word or phrase between the quotes and still
have a large number of them to complete.