Count the cells that are not empty (numbers and text).
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
COUNTA(value1, [value2], …)COUNTA counts every non-blank cell, including text, numbers, and errors. Use COUNT for numbers only, and COUNTBLANK for empties.
=COUNTA(A2:A100)Result: 87
Counts filled rows (e.g. how many records).
COUNT counts only numeric cells; COUNTA counts any non-empty cell including text.