To count the number of cells containing content, i.e., those that aren't blank, in Google Sheets, which is part of Google Docs and is Google's online equivalent of Microsoft Excel you can use
COUNTIF
or COUNTA
. E.g., suppose you wish to count the number of cells
in column A from A2 to A64 which contain data, ignoring any cells that are
blank. You could use COUNTIF(A2:A64,"<>")
. The
"<>"
, instructs Google Sheets to only count cells that
don't have a null value, i.e., ones containing some data. Alternatively,
you could use COUNTA(A2:A64)
. If you wanted the number that
were blank, you could use COUNTBLANK(A2:A64)
.