# Count cells that do not contain numbers and ignore blank in Excel/Sheets

=COUNTIF(A2:A6,"*")

### A2:A6 = Range

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

# Count cells that do not contain numbers and ignore blank in Excel

How to count cells that do not contain numbers and ignore blank in Excel?

# COUNT CELLS THAT DO NOT CONTAIN NUMBERS AND IGNORE BLANK — EXCEL FORMULA AND EXAMPLE

=COUNTIF(A2:A6,"*")

• To count within multiple Ranges =COUNTIF(A1:B6,"*")

• To count within multiple Columns =COUNTIF(A:B,"*")

# Count cells that do not contain numbers and ignore blank in Google Sheets

How to count cells that do not contain numbers and ignore blank in Google Sheets?

# COUNT CELLS THAT DO NOT CONTAIN NUMBERS AND IGNORE BLANK — GOOGLE SHEETS FORMULA AND EXAMPLE

1. =COUNTIF(A2:A6,"*")

2. =SUMPRODUCT(NOT(ISNUMBER(A2:A6)))-COUNTBLANK(A2:A6)

• To count within multiple Ranges =COUNTIF(A1:B6,"*")

• To count within multiple Columns =COUNTIF(A:B,"*")