COUNT


Description Returns the number of values in the supplied list.

Syntax COUNT ( value_list )
Argument Description
value_list A list of values. The list can contain as many as 30 values.

Remarks COUNT only numerates numbers or numerical values such as logical values, dates, or text representations of dates. If you supply a range, only numbers and numerical values in the range are counted. Empty cells, logical values, text, and error values in the range are ignored.

Examples This function returns 2:

COUNT(5, 6, "Q2")

This function returns 3:

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

See Also AVERAGE, COUNTA, SUM