Count Cells that contain specific text

I am trying to count a list of keywords and return the specific value in a certain cell.

excel sample.gif

So if the cell A3 contains the word relief teaching, the value in B3 is moved into the cell C3.

Does anyone know the formulae for this?

Your help is greatly appreciated.

Bob

Of course. I am such a dope.

Attached is the file.

This is keyword data from my website.

I need to identify which key words are most significant.

I want to count the number of times a phrase (eg, relief teaching) occurs.

So I need to formula to identify is the phrase exist, then it copies the value of the the cell into the correct column.

So the formula in c3 should return a value = b3 if a3 contains the phrase "relief teaching"

Likewise the formula in d3 should return a value = b3 is a3 contains the phrase "relief teacher"

I have attached the file as a link.

I hope this is OK.

Happy New Year to you too.

Bob

http://www.reliefteaching.com/blog/keywords.xlsx

That does the trick Tony.

Thank you.

Bob

Originally Posted by Tony Valko

Try this...

Entered in C2:

=IF(COUNT(SEARCH(" "&C$1&" "," "&$A2&" ")),$B2,"")

Copy across as far as needed then down as far as needed.

Your formula fail on "reliefteaching.com" . It is the same as "relief teaching". See the row 9 of the OP attachment on post #5.