Does not equal

P

phil2006

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
 
B

Bob Phillips

=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)
 
M

Mallycat

phil2006 said:
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
Click to expand...

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
 
Top