How to use the Operations If Not Equal To in Excel

Excel uses <> sign as not equal to operator. Put “<>” between two expressions to use it. This (<>) operator excludes any matching value from calculation.

Count If Not Equal To

Generic Formula

=COUNTIF(range,”<>value”)

=COUNTIF(range,”<>” & Cell Reference)

Example:

So we have this data of Apples.

We want to count apples that are Not OK using not equal to (<>) sign.

Write this formula in Cell G3:

=COUNTIF(D3:D12,"<>OK")

This COUNTIF exclude all OK values from range D3:D12 and counts remaining values.

Sum If Not Equal To

Generic Formula

=SUMIF(sum_range,”<>value”, sum_range)

=SUMIF(sum_range,”<>” & Cell reference, sum_range)

Now lets sum the prices whose value is not equal to 20.

Write SUMIF formula in Cell G6:

=SUMIF(E3:E12,"<>20",E3:E12)

This The SUMIF function will exclude all values that are equal to 20 in range D3:D12 and sums remaining values.

So yeah guys, this is where most people get stuck but its easy to do. You just didn’t know about Not Equal To operator in Excel. Now you do.