Skip to main content

COUNTA

Counts the number of cells that are not empty in a range.

CategoryStatistical
SyntaxCOUNTA(value1, [value2], ...)

Parameters

ParameterRequiredDescription
value1RequiredThe first item, cell reference, or range in which to count non-empty cells.
value2OptionalAdditional items, cell references, or ranges.

Example

COUNTA(A1:A10)

Auto-generated from the EngCanvas function registry.