COUNTA (number of cells filled)

<< Click to Display Table of Contents >>

COUNTA (number of cells filled)

Syntax:

COUNTA(Range1 [, Range2, Range3 ...])

Description:

Counts the number of cells containing any kind of value (i.e., cells that are not empty).

The cells may contain any numbers, text strings, logical values or error values.

Example:

If the cells A1:A3 contain 42, "Test" and TRUE and cell A4 is empty. The following applies:

COUNTA(A1:A4) returns 3

For comparison: COUNT(A1:A4) returns 1

Annotation:

The COUNT function works similarly, but only counts cells with numbers.

See also:

COUNT, ISBLANK