How do you use the equivalent of NOT in text?

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I am analizing the incedence of certain words in the search strings from my
website

my formula is =SUMIF($I$2:$I$58,"*"&L2&"*",$G$2:$G$58)

this tells me how many times a word appears in a string of text eg. apples

I want to find out how many times a word appears without another word. i.e.
I want to exclude the results with for "english"and" apples", but I want all
the other strings including "apples" added.

Any ideas?
 
How about

=SUMPRODUCT(--(ISNUMBER(SEARCH(L2,$I$2:$I$58))),--(NOT(ISNUMBER(SEARCH(L3,$I$2:$I$58)))),$G$2:$G$58)

HTH

Bob
 
Another one...

=SUMPRODUCT(--(ISNUMBER(SEARCH(L2,$I$2:$I$58))),--(ISERROR(SEARCH(L3,$I$2:$I$58))),$G$2:$G$58)
 
Back
Top