Count cells that are not blank in Excel and Google Sheets

To count the number of cells that are not blank, you can use =COUNTA(A2:A6) or =COUNTIF(A:A,"<>") formulas. Check the formulas below that suits your need.

=COUNTA(A2:A6)

=COUNTIF(A2:A6,"<>")

=COUNTIF(A:A,"<>")

A2:A6, A:A = Ranges, "<>" = Blank Condition

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

Count cells that are not blank in Excel

How to count non-blank cells in Excel?
Count cells that are not blank in Excel

COUNT CELLS THAT ARE NOT BLANK — EXCEL FORMULA AND EXAMPLE

Count cells that are not blank in Google Sheets

How to count non-blank cells in Google Sheets?
Count cells that are not blank in Google Sheets

COUNT CELLS THAT ARE NOT BLANK — GOOGLE SHEETS FORMULA AND EXAMPLE

Wild cards and regular expressions in Excel and Google Sheets

Wild cards and regular expressions
Other useful "COUNT FUNCTIONS: TEXT BASED CRITERIA" formulas in Excel and Google SheetsOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions