COUNT function

Counts the number of arguments that contain numbers.

Syntax

COUNT(value1,value2,...)

Value1, value2, ...     are 1 to 30 arguments that can contain or refer to a variety of different types of data, but only numbers are counted.

Remarks

• Arguments that are numbers, dates, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers are ignored.

• If you need to count logical values, text, or error values, use the COUNTA function.

Examples

Col1	Col2	Col3	Col4	Col5	Col6	Col7	Formula	Description (Result)
Sales	12/8/2008		19	22.24	TRUE	#DIV/0!	=COUNT([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7])	Counts the number of arguments that contain numbers in the list (3)
			19	22.24	TRUE	#DIV/0!	=COUNT([Col4],[Col5],[Col6],[Col7])	Counts the number of arguments that contain numbers in the last 4 rows of the list (2)
Sales	2/8/2008		19	22.24	TRUE	#DIV/0!	COUNT([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7],2)	Counts the number of arguments that contain numbers in the list, and the value 2 (4)