IF does NOT equal formula ???

Is it possible to do an IF formula based around a value it does not equal?

eg I have one column, that is perforning a SUMIF providing that a certain cell is equal to a particular constant.

=IF([cell]=[value],SUMIF([range],[criteria],[sum_range]))

In the next column I want to do it the other way round so that:

=IF([cell] DOESNOT=[value],SUMIF([range],[criteria],[sum_range]))

Is it just a simple symbol??

Thanks

What about <> means is not equal to
e.g If(A1<>"A","A","B")
reading: If Cell A1 is not equal to the string "A" then ... You'll understand the rest. In your case it could even be

Please Login or Register  to view this content.

Note the additional comma!