# How to Count Cells Not Equal to Value in Excel

To count cells not equal to a specific value in Excel, you can use the COUNTIF function. The COUNTIF function allows you to count the number of cells that meet a specific criterion, such as not being equal to a given value.

Here's a step-by-step guide on how to use COUNTIF to count cells not equal to a value in Excel:

- Open your Excel workbook and navigate to the worksheet containing the data you want to count.
- Click on an empty cell where you want to display the count of cells not equal to the given value.
- Type the following formula in the selected cell:

`=COUNTIF(range,"<>value")`

Replace `range`

with the range of cells you want to count (e.g., A1:A10), and replace `value`

with the specific value you want to exclude from the count (e.g., 5 or "text").

- Press Enter, and Excel will display the count of cells in the specified range that are not equal to the given value.

### Example

Let's say you have a list of numbers in the range A1:A10 and you want to count the number of cells that are not equal to 5.

- Click on an empty cell where you want to display the count.
- Type the following formula in the selected cell:

`=COUNTIF(A1:A10,"<>5")`

- Press Enter, and Excel will display the count of cells in the range A1:A10 that are not equal to 5.

Did you find this useful?