Statistical

Excel COUNTA Function

Count the cells that are not empty (numbers and text).

Syntax

COUNTA(value1, [value2], …)

Arguments

value1required

The first range to count.

value2…optional

Additional ranges.

What the COUNTA function does

COUNTA counts every non-blank cell, including text, numbers, and errors. Use COUNT for numbers only, and COUNTBLANK for empties.

=COUNTA(A2:A100)→87

Counts filled rows (e.g. how many records).

Select the range

Point at the column or block to count.

COUNTA vs COUNT?

COUNT counts only numeric cells; COUNTA counts any non-empty cell including text.