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" wrote in 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!

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!
.