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

=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

phil2006 Wrote:
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

The standard does not equal string is <

ie =SUMIF(A1:A5,"<3",A1:A5) will add all the non 3 numbers in the
range

Matt


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

Thanks very much!


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