Count cells not equal to in Excel and Google Sheets
=COUNTIF(A:A,"<>10")-COUNTBLANK(A:A)
=COUNTIF(A:A,"<>"&B3)-COUNTBLANK(A:A) // Criteria as a cell reference
A:A = Range
Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.Count cells not equal to in Excel
How to count cells not equal to in Excel?
COUNT CELLS NOT EQUAL TO — EXCEL FORMULA AND EXAMPLE
=COUNTIF(A:A,"<>10")-COUNTBLANK(A:A)
COUNTBLANK(A:A) // subtract the number of blank cells
Criteria within the formula and must be inside the quotation mark
=COUNTIF(A:A,"<>"&B3)-COUNTBLANK(A:A)
COUNTBLANK(A:A) // subtract the number of blank cells
Condition within the formula and must be inside the quotation mark
Criteria as a cell reference
=COUNTIF(A:A,B4)-COUNTBLANK(A:A)
COUNTBLANK(A:A) // subtract the number of blank cells
Criteria as a cell reference
=COUNTIF(A:A,B5)-COUNTBLANK(A:A)
COUNTBLANK(A:A) // subtract the number of blank cells
Criteria as a cell reference
💡 Excel COUNTIF will include blank cell as well and we need to subtract the number of blank cells "-COUNTBLANK(A:A)" in the actual formula
Count cells not equal to in Google Sheets
How to count cells not equal to in Google Sheets?
COUNT CELLS NOT EQUAL TO — GOOGLE SHEETS FORMULA AND EXAMPLE
=COUNTIF(A:A,"<>10")
Criteria within the formula and must be inside the quotation mark
=COUNTIF(A:A,"<>"&B3)
Condition within the formula and must be inside the quotation mark
Criteria as a cell reference
=COUNTIF(A:A,B4)
Criteria as a cell reference
=COUNTIF(A:A,B5)
Criteria as a cell reference
Wild cards and regular expressions in Excel and Google Sheets
- Count blank cell
- Count cell between two values
- Count cells greater than
- Count cells greater than and equal
- Count cells less than
- Count cells less than and equal to
- Count cells that contain numbers and ignore blank
- Count cells that do not contain numbers and ignore blank
- Count number of days between dates
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Combine two or more cell
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Convert date to text
- Convert time to text
- Convert weekday string to number
- Combine two or more cells with a line break
- Combine two or more cells and transpose
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria