COUNTA

Description

COUNTA returns the number of nonblank values in the supplied list.

Syntax

COUNTA ( expression_list )

Parameter	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)

Note:

If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.)

Also, see