Excel uses <> sign as not equal to operator. Put “<>” between two expressions to use it. This (<>) operator excludes any matching value from calculation.
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:
This COUNTIF exclude all OK values from range D3:D12 and counts remaining values.
Now lets sum the prices whose value is not equal to 20.
Write SUMIF formula in Cell G6:
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.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.