Site icon ExcelNotes

How to Count Cells with Values Not Equal to

The COUNTIF function counts the number of cells that meet one criterion, such as the cells with a text string, the cells with a certain value, etc. The following formula is to help you get the count of cells not equal to a particular value.

Example: You are working with a dataset with the first name in column A, the last name in column B, and the salary in column C.

Formula 1: How many people's salaries are not equal to $80,000?

= COUNTIF(C2:C8, "=80000")

The result returns ten, and there are ten people with a salary equal to $80,000.

Formula 2: How many people's salaries are not equal to $100,835?

= COUNTIF(C2:C8, "=100835")

The result returns ten, and there are ten people with a salary equal to $100,835.

Notes: The COUNTIF function

Formula:

= COUNTIF(Range, "=number")

Explanations:

– The range is required, the range of cells you want to count;
– The number is required, which is the base number.

Exit mobile version