COUNTA


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:

COUNTA(32, 45, "Earnings", "")

This function returns 0 when the specified range contains empty cells:

COUNTA(C38:C40)

See Also AVERAGE, COUNT, PRODUCT, SUM