how to return a number for how many times a word is used in excel

[James Houck]

I am designing a spreadsheet and cannot figure out the formula to return a
number for how many times a word has been used in a range of cells. Please
help.

 

[David Billigmeier]

SUMPRODUCT(--ISNUMBER(SEARCH("<word to search for>",<range>)))