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.