Use the math operators <

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

Mike

"Fred Holmes" wrote:

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