How do I calculate times each word occurs in a column of cells?

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.

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

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
>

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

Here's one "something else"<g>, with word to count entered into C1:

=SUMPRODUCT(LEN(A2:A100)-LEN(SUBSTITUTE(UPPER(A2:A100),UPPER(C1),"")))/LEN(C1)

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> 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