COUNTIF text where there is more than one word in a cell

I tried the COUNTIF function on a range of cells to count a specific word in
that range, but these cells have multiple words in them and the formula
doesn't recognize the words then.

How do I expand my countif formula to get what I need?

EXAMPLE
A1: apple and orange
A2: apple and banana
A3: apple and grapes and orange
A4: pineapple

=COUNTIF(A1:A4,"apple") is what I currently have but it returns a value of
zero. How do I get it to return the value of four that I'm looking for?

Thanks!

=COUNTIF(A1:A4,"*apple*")



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Abi" <[email protected]> wrote in message
news:[email protected]...
>I tried the COUNTIF function on a range of cells to count a specific word
>in
> that range, but these cells have multiple words in them and the formula
> doesn't recognize the words then.
>
> How do I expand my countif formula to get what I need?
>
> EXAMPLE
> A1: apple and orange
> A2: apple and banana
> A3: apple and grapes and orange
> A4: pineapple
>
> =COUNTIF(A1:A4,"apple") is what I currently have but it returns a value of
> zero. How do I get it to return the value of four that I'm looking for?
>
> Thanks!

Hi!

Here's one way:

=COUNTIF(A1:A4,"*apple*")

The asterisks are wildcards.

Biff

>-----Original Message-----
>I tried the COUNTIF function on a range of cells to count
a specific word in
>that range, but these cells have multiple words in them
and the formula
>doesn't recognize the words then.
>
>How do I expand my countif formula to get what I need?
>
>EXAMPLE
>A1: apple and orange
>A2: apple and banana
>A3: apple and grapes and orange
>A4: pineapple
>
>=COUNTIF(A1:A4,"apple") is what I currently have but it
returns a value of
>zero. How do I get it to return the value of four that
I'm looking for?
>
>Thanks!
>.
>