How do you use the equivalent of NOT in text?

[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?

 

[Bob Phillips]

How about

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

HTH

Bob

 

[T. Valko]

Another one...

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