Description
Returns the number of nonblank values in the supplied list.
Syntax
COUNTA ( expression_list )
| Parameter | Description |
|---|---|
| expression_list | A list of up to 30 comma-separated expressions or source fields. |
Remarks
Source fields can contain only a single value.
Null values (" ") are counted, but references to empty fields are ignored.
If there are no numbers in the list, 0 is returned.
Examples
This function returns 4:
COUNTA(32, 45, "Earnings", "")
This function returns 0 when the specified range contains empty fields:
COUNTA(S1:S3)
For the following example, assuming that S7 contains 34, S8 contains 227, and S9 contains "TRUE", this function returns 3:
COUNTA(S7,S8,S9)
See also