Finding text

  • Thread starter Thread starter Meebers
  • Start date Start date
M

Meebers

If I have text in a cell = "I love Excel", I want to find and count the
number of times "Excel" appears in a range. CountIF seems to want all
words. TIA
 
Your formula returns #VALUE! error
=SUM(IF(FIND("Excel",A1:A100,1),1,0))
Click to expand...

Try like this:

=SUM(IF(ISNUMBER(SEARCH("Excel",A1:A100)),1))
ctrl+shift+enter, not just enter

or
=COUNTIF(A:A,"*Excel*")
 
Great...seems that =COUNTIF(A:A,"*Excel*") works ok and is a smaller
formula. I see that the "*" must specify a wildcard, thats where my error
was. Tx....
 
Back
Top