COUNT

See also A-Z Spreadsheet Function List

Description Returns the number of values in the supplied list.

Syntax COUNT(value_list)

value_list is a list of values. The list can contain as many as 30 values.

Remarks COUNT only numerates numbers or numerical values (e.g., 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.

See Also AVERAGE , COUNTA , and SUM functions

Examples COUNT(5, 6, “Q2”) returns 2

         COUNT(“03/06/94”, “06/21/94”, “10/19/94”) returns 3