Count If Not Equal To

Excel formula: Count cells not equal to

To count the number of cells that contain values that not equal to a specified value, such as below screenshot shown. In Excel, yous can use the COUNTIF function to quickly handle this job.
doc count cells equal to 1

Generic formula:

Arguments

Range: Required, the cells y'all want to count that match to criteria from.
Value: Required, the criteria that the cells need to friction match to while counting.

Example:

Count the number of cells that not equal to "Apple tree" in the given list, choose one of below formulas

=COUNTIF(B2:B8,"<>Apple")

In higher up formulas, B2:B8 is the range of cells that y'all want to count from, Apple tree and E2 is the value you lot desire the cells not equal to.

The press Enter key to go the counted result

Sample File

doc sample Click to download sample file

Relative Formulas

Count cells equal to
With the COUNTIF function, yous can count cells that equal to or not contain a specified value.
Count cells that equal to ten or y
In some times, you may want to count the number of cells that see one of two criteria, in this case, yous can use the COUNTIF function.
Count cells equal to x and y
Here this article introduce the formula to count cells that at the meanwhile friction match two criteria.
Count cells greater than or less than
This article talks about how to use the COUNTIF part to count the number of cell that greater than or less than a number

The Best Office Productivity Tools

Kutools for Excel - Helps Y'all To Stand Out From Crowd

Would y'all like to consummate your daily work speedily and perfectly? Kutools for Excel brings 300 powerful advanced features (Combine workbooks, sum by colour, split cell contents, catechumen appointment, and and then on...) and salve 80% time for you lot.

Designed for 1500 work scenarios, helps yous solve lxxx% Excel problems.
Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
Go an Excel adept in 3 minutes. No longer need to remember any painful formulas and VBA codes.
thirty-solar day unlimited free trial. 60-twenty-four hours coin back guarantee. Costless upgrade and back up for 2 years.

Ribbon of Excel (with Kutools for Excel installed)

Office Tab - Enable Tabbed Reading and Editing in Microsoft Role (include Excel)

One second to switch between dozens of open documents!
Reduce hundreds of mouse clicks for yous every solar day, say goodbye to mouse hand.
Increases your productivity past 50% when viewing and editing multiple documents.
Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Firefox, And New Internet Explorer.