How can I count how many time a word appears in a range of cells, if there is more than one word in the cell.
For example (reference the attached): Counting how many times "pump" appears in the list attached. Or "flowmeter"? Given there are other words/numbers in the cell along with the specified word I am not sure how exactly to write the formula.
Bookmarks