Excel 2000

Is there a way to write a SUMIF formula such that one sums rows that
do NOT match the criterion? Something like:

=SUMIF(A3:A1000,NOT("Total*"),C3:C1000)

But the middle item, the criterion, needs to be a string, not a
logical.

Many thanks,

Fred Holmes