Home ➜ Excel Formulas ➜ **Count Cells Not Equal To (COUNTIF)**

In Excel, you can use the COUNTIF function to count the cells that are not equal to a specific value you define.

You need to specify the range of values to check and the criteria that you want to test.

In the following example, you have a list of values in form of numbers and now from here, you need to count the number of values that are not equal to zero.

=COUNTIF(A2:A15,”<>0″)

- First, you need to enter the COUNTIF function in cell C1 and enter the starting parentheses.
- Next, select the range from which you want to count the values.
- After that, type a comma to move to the next argument.
- In the end, enter “<>0” in the criteria and close parentheses.

When you hit enter, it returns the count of the numbers that are not equal to zero.

Now as you can see you have used the symbol <> before the zero.

This symbol is a combination to lower than and greater than signs and when you use both signs collectively, it means “not equals”.

You need to take care of one more thing you need to enclose the criteria in double quotation marks.

## More Formulas

- Count Between Two Numbers (COUNTIFS)
- Count Blank (Empty) Cells using COUNTIF
- Count Cells Less than a Particular Value (COUNTIF)
- Count Cells That Are Not Blank
- Count Cells with Text in Excel
- Count Greater Than 0 (COUNTIF)
- Count Specific Characters
- Count Unique Values in Excel [Formulas + VBA]
- Count Words in Excel
- OR Logic in COUNTIF/COUNIFS in Excel
- Count Total Number of Cells from a Range