|
<< Click to Display Table of Contents >> 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
Additional info:
The COUNT function works in a similar manner, but it only counts cells with numbers.
See also: