Counting cells containing certain words

I would use the "Find" function and link to the range of cells I'm looking for.
If it doesn't find it, it will render an error.
Then I'd use the =IFERROR function to weed out the errors.
You'll have a list of the ones that match, and the ones that don't will be blank, or whatever value you've assigned in the iferror formula.

Moderators note: Please do not post links to commercial web sites. I have removed the link

Thanks