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".

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

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

3. 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.