View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MTSusce MTSusce is offline
external usenet poster
 
Posts: 2
Default How do I calculate times each word occurs in a column of cells

Thanks, Dave. :^) Meg

"Dave Peterson" wrote:

If the word only occurs once per cell (or 0 per cell):

=countif(a1:a100,"*yourword*")

If the word can occur more than once in a cell, then you'll need something else.

MTSusce wrote:

Rather than use a complicated array formula, is there a simpler way to
determine how many times a particular word occurs in a range of cells in a
column? Thank you.


--

Dave Peterson