=SUMIF(A:A,"<10",B:B)

or

=SUMIF(A:A,"<"&H1,B:B)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"phil2006" wrote in
message ...

Is there a function that can be used for when a box does not equal the
criteria? Essentially I am doing a sumif function but also want a sumif
not formula to add to the function.

Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=553961