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


--
David Billigmeier


"James Houck" wrote:

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.