# How to COUNTIF Not Equal to Text in Google Sheets

To use COUNTIF with Not Equal to Text in Google Sheets, you can use the following formula:

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

Here, `range`

refers to the range of cells where you want to count the values, and `text`

refers to the text value you want to exclude from the count.

## Example

Let's say you have a list of fruits in cells A1:A10, and you want to count the number of cells that do not contain the text "Apple".

- Click on an empty cell where you want to display the count, for example, B1.
- Enter the following formula in the cell:

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

- Press Enter.

The formula will count the number of cells in the range A1:A10 that are not equal to "Apple" and display the result in cell B1.

Did you find this useful?