Sum if cells are not equal to

Generic formula 

=SUMIF(range,"<>value",sum_range)

Explanation 

To sum cells when other cells are not equal to a specific value, you can use the SUMIF function.

In the example shown, cell H7 contains this formula:

=SUMIF(region,"<>West",amount)

This formula sums the amounts in column E only when the region in column C is not "West".

How the formula works

The SUMIF function supports all of the standard Excel operators, including not-equal-to, which is input as <>.

When you use an operator in the criteria for a function like SUMIF, you need to enclose it in double quotes (""). In this case, the criteria is input as "<>West" which you can read as "not equal to West", or simply "not West".