Count cells that contain numbers and ignore blank in Excel and Google Sheet

=COUNT(A2:A6)

=COUNT(A2:A6,"<>*")

A2:A6 = Ranges

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

Count cells that contain numbers and ignore blank in Excel

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

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

Count cells that contain numbers and ignore blank in Google Sheets

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

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