Count specific words in a cell

[lousydull]

Hello All,

Can someone please help me how to count specific words in a single cell using formula? Example cell A1 "My computer works fine. I need formula that would count the words computer and works. ​Thanks

 

[SteveO59L]

=IF(FIND("computer",C4)>1,1,0)+IF(FIND("works",C4)>1,1,0)

 

[lousydull]

=IF(FIND("computer",C4)>1,1,0)+IF(FIND("works",C4)>1,1,0)

Thanks Steve!

Tested your formula and it works fine. Unfortunately I realized that it wasn't what I wanted to happen. Example in A1 texts are "3PT, COD, INS, DIM, TAC". I only want to count the text "3PT and COD" thus, it will only return "2" (count for 3PT & COD). The bottom line is regardless of what text I entered, it will only count the text I will specify in a function/formula.

 

[Peter_SSs]

Welcome to the MrExcel board!

Unfortunately I realized that it wasn't what I wanted to happen. Example in A1 texts are "3PT, COD, INS, DIM, TAC". I only want to count the text "3PT and COD" thus, it will only return "2" (count for 3PT & COD). The bottom line is regardless of what text I entered, it will only count the text I will specify in a function/formula.

What you do want to happen is unclear to me. Can you give 4 or 5 examples instead of just one, and the expected result(s) for those examples, and explain again in relation to those examples?