View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike G Mike G is offline
external usenet poster
 
Posts: 26
Default Counting # of occurances of words in text

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?