# Learn How to Count Cells Not Equal To in Microsoft Excel

Written by | 0 Comments | 315 Views

In this article, you will learn how to use the Microsoft Excel COUNT formula and its purpose in Microsoft Excel. You will also get to know how to count cells not equal to others and see the generic formula.

Count Cells Not Equal To in Microsoft Excel

The main purpose of the Microsoft Excel COUNTIF formula is to count the number of cells that contain values not equal to a particular value. Here we will learn how to count cells not equal to in Microsoft Excel.  That implies, with the help of the COUNTIF function you can able to count the number of cells that having values that are not equal to a particular value, and for this, the COUNTIF function can be used. In the generic form of the formula provided below rng represents a range of cells, and X represents the value you don't want to count. So, with the help of this formula, you can able to count the number of cells that contain values not equal to a particular value.

General Formula to COUNT Cells Not Equal To

=COUNTIF(rng,"<>X")

The Explanation for the COUNT Cells Not Equal To

So we know that Microsoft Excel COUNTIF function you can able to count the number of cells that contain values not equal to a particular value. Here we will learn how to count cells not equal to in Microsoft Excel. As we know that, the operator for not equal is "<>" in Microsoft Excel. The COUNTIF function counts the number of cells in a range that meets provided criteria. It should be noted that while using the not equal to an operator in COUNTIF, you must enclose it in double quotes.

It should be noted that if you want to use a value in another cell as part of the criteria, use the ampersand (&) character to concatenate. So, with the help of the COUNT formula, you can able to count the number of cells that contain values not equal to a particular value.