<< 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: