FUNCTION CATALOGUE / STATISTICAL
COUNTA Excel function
Counts non-empty cells.
Correct sentence to use
Count non-empty cells in [range].
Modify this query in PlainFormula →Example formula
=COUNTA(A2:A25)
Counts cells that are not empty.
Syntax
COUNTA(value1, [value2], …)
Argument signature: value1, [value2], …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.