COUNTA function in Excel

COUNTA counts cells that are not empty.

Syntax

=COUNTA(value1, [value2], …)

Argument	Required?	What it is
value1	Required	The first value, cell or range.
value2, …	Optional	More values (optional).

Type the formula yourself and get it graded instantly, no Excel needed.

COUNTA counts cells that are not empty.

=COUNTA(value1, [value2], …)

Argument	Required?	What it is
value1	Required	The first value, cell or range.
value2, …	Optional	More values (optional).

Type the formula yourself and get it graded instantly, no Excel needed.