COUNTA

See also A-Z Spreadsheet Function List

Description Returns the number of non-blank values in the supplied list.

Syntax COUNTA(expression_list)

expression_list is 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.

See Also AVERAGE , COUNT , PRODUCT , and SUM functions

Examples COUNTA(32, 45, “Earnings”, "") returns 4

         COUNTA(C38:C40) returns 0 when the specified range contains empty cells