COUNTA Function

The COUNTA function is one of the statistical functions. It is used to analyze the range of cells and count the number of cells that are not empty.

Syntax

COUNTA(value1, [value2], ...)

The COUNTA function has the following arguments:

Argument	Description
value1	The first value you wish to count.
value2/n	Additional values you wish to count.

Notes

How to apply the COUNTA function.

Examples

The figure below displays the result returned by the COUNTA function.