Description Returns the number of nonblank values in the supplied list.
Syntax COUNTA ( expression_list )
Argument | Description |
---|---|
expression_list | A list of expressions. As many as 30 expressions can be included in the list. |
Remarks COUNTA returns the number of cells that contain data in a range. Null values (" ") are counted, but references to empty cells are ignored.
Examples This function returns 4:
This function returns 0 when the specified range contains empty cells:
See Also AVERAGE, COUNT, PRODUCT, SUM