Replace Part of a Function

[Walter]

=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.

 

[Rick Rothstein \(MVP - VB\)]

I'm not completely sure what you are asking. Are you saying you have a list
of words in Column K and you want to apply the COUNTIF function against each
word? If so, just reference the first cell in Column K and then copy the
formula down. That is, put this in Column L....

=COUNTIF(F:F,K1)

and then copy it down for as many rows as are in the list in Column K.

Rick

 

[Alan]

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