Functions
COUNTA
Count non-empty values
Try it
When to use it
When should I use COUNTA instead of COUNT?
Use COUNTA to count every non-empty value, including text and logicals; use COUNT when you only want numbers.
Does COUNTA count blank cells?
No. COUNTA counts any cell that contains data of any type, but it skips truly empty cells.
Use cases
Count non-empty responses in a row
Tally any kind of recorded value
Used in
Syntax
COUNTA(value1,...)Examples
=COUNTA(1,2,3,4,5) // => 5
=COUNTA(4,26,1,2,3) // => 5