Forum Discussion
Solved
count occurrences of text in a cell range
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...
=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.
=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.
That's it, exactly. Funny that your solution did not come up when I searched for formulas. Thanks much.