Formulas and functions > Functions from A to Z > COUNTA (number of cells filled)

Syntax:

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

Description:

This determines the number of cells containing any kind of value (thus, cells that are not empty).

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

Example:

If 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

Note:

The COUNT function works in a similar manner, but it only counts cells with numbers.