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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top