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 in Excel

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

=COUNTIF(A2:A6,"*")

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 in Google Sheets

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