COUNTA function


DESCRIPTION:

Count non-empty cells in a range.

 

SYNTAX:

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

 

REQUIRED ARGUMENTS:

value1

The first value.

 

OPTIONAL ARGUMENTS:

[value2]

The second value.

 

EXAMPLE:

The following example counts cells that are not blank (in range A1:E2).

In this range only cells A1, B2 and E2 are not blank, so the function returns 3.

 

NOTES:

You have to be careful because any value will be counted, even space.

 

ADDITIONAL EXAMPLES:

 

RELATED FUNCTIONS:

 

MORE RESOURCES: