COUNT

Description

COUNT returns the number of values in the supplied list.

Syntax

COUNT ( value_list )

Remarks

COUNT numerates numbers and numerical values, dates, or text representations of numbers. If you supply a range, only numbers and numerical values and dates in the range are counted. Empty cells, logical values, text, and error values in the range are ignored. However, logical values and text representations of numbers that you type directly into the list of arguments are counted.

Examples

This function returns 2:

COUNT(5, 6, "Q2")

This function returns 3:

COUNT("03/06/94", "06/21/94", "10/19/94")

 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

AVERAGE

COUNTA

SUM