Dec 13 2021 04:34 AM
Excel 2016. I would like to count the number of times a particular word appears in a range of cells, some of which contain more than one word. COUNTIF only finds words if they are exact matches and no other words in a cell. Example, find the word bob in the range of 4 cells below.
bob
bob loves jane
jane
love
COUNTIF would return 1 but my formula should return 2
Dec 13 2021 04:42 AM
Solution=COUNT(SEARCH(E3,C4:C7))
Is this what you want to do? Enter above formula as matrixformula with ctrl+shift+enter if you don't work with Office365 or 2021.
Dec 13 2021 04:53 AM
That's it, exactly. Funny that your solution did not come up when I searched for formulas. Thanks much.
Dec 13 2021 04:42 AM
Solution=COUNT(SEARCH(E3,C4:C7))
Is this what you want to do? Enter above formula as matrixformula with ctrl+shift+enter if you don't work with Office365 or 2021.