=(len(a1)-len(substitute(a1,"good","")))/len("good")


Mike G wrote:

If I have a cell that contains "good things come in good packages" and want
to count the number of occurances of the word "good" how would I do that?
Have tried countif and sumproduct and both give me #name?

--

Dave Peterson