Calc: What is the negate of "*text*"?

[BeOS]

How can I negate this LibreOffice Calc condition so that the sum only applies to cells that don’t have the word TEXT:

=SUMIFS(B1:B118, C1:C118, "*TEXT*")

I tried a few expressions such as

NOT("*TEXT*")
!"*TEXT*"
<>"*TEXT*"

And none of them seem to be valid.

[mikekaganski]

=SUMIFS(B1:B118, C1:C118, "<>*TEXT*")