You can use the following formulas to count the number of cells in Excel not equal to some value:

**Method 1: Count Cells Not Equal to Value**

=COUNTIF(A1:A100, "<>value")

This formula counts the number of cells in the range **A1:A100** that are not equal to **value**.

**Method 2: Count Cells Not Equal to Several Values**

=COUNTIFS(A1:A100, "<>value1", A1:A100, "<>value2", A1:A100, "<>value3")

This formula counts the number of cells in the range **A1:A100** that are not equal to **value1** *or* **value2** *or* **value3**.

The following examples show how to use each method in practice.

**Example 1: Count Cells Not Equal to Value**

Suppose we have the following data in Excel:

We can use the following formula to count the number of cells in the **Team** column that are not equal to “A”:

=COUNTIF(A2:A13, "<>A")

The following screenshot shows how to use this formula in practice:

This tells us that there are **10** cells in the **Team** column not equal to “A.”

**Example 2: Count Cells Not Equal to Several Values**

Once again suppose we have the following data in Excel:

We can use the following formula to count the number of cells in the **Team** column that are not equal to “A” *or* “B”:

=COUNTIFS(A2:A13, "<>A", A2:A13, "<>B")

The following screenshot shows how to use this formula in practice:

This tells us that there are **4 **cells in the **Team** column not equal to “A” *or* “B.”

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Count Filtered Rows in Excel

How to Use COUNTIF with OR in Excel

How to Use COUNTIF From Another Sheet in Excel