COUNT

Used only in ReliaSoft Workbooks

Description: Counts the number of cells that contain numbers within the list of arguments. Use COUNT to get the number of entries in a number field in a range or array of 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 representation of numbers are counted.
• Logical values and text representations of numbers that you type directly into the list of arguments are counted.
• Arguments that are error values or text that cannot be translated into numbers are ignored.
• If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text or error values in the array or reference are ignored.
• If you want to count logical values, text or error values, use the COUNTA function.

Example:

• In the following example,

	A
1	Data
2	Sales
3	12/8/2010
4
5	19
6	22.24
7	TRUE
8	#DIV/0!

 

COUNT(A1:A7) = 3 [the number of cells that contain numbers in the list above]

COUNT(A4:A7) = 2 [the number of cells that contain numbers in the last 4 rows of the list]

COUNT(A1:A7, 2) = 4 [the number of cells that contain numbers in the list, and the value 2]