Actually, the suggested "<Total*" appears to work just fine.

It is logically equivalent to your suggested "<"&"Total*".

Originally, I didn't think of using wild cards in the string, but that
does seem to make sense.

Fred Holmes

On Fri, 8 Jun 2007 08:08:50 -0500, "Don Guillett"
wrote:


"<"& "total"
--
Don Guillett
SalesAid Software

"Fred Holmes" wrote in message
.. .
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