All functions / Statistics

COUNTA

Counts cells that are not empty.

Syntax

=COUNTA(value1, [value2], …)

Arguments

• value: Cells or ranges to count.

Example

=COUNTA(A1:A20) → How many filled cells

Practise it

• Counting cells
• Spilling arrays: UNIQUE and SORT
• Challenge: the class gradebook