Manuals/calci/COUNT

=COUNT(V1, V2...)

• Where V1, V2 ...   are the arguments.

• COUNT() returns the number of cells that contain numbers, and also numbers within the list of arguments.

• Arguments can be numbers, dates or text representation of numbers.

• Logical values, text, error values are ignored.

Description

COUNT(V1,V2...)

Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) returns 4 as a result.

COUNT((A1:A8),7,13) returns 6 as a result.

• The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.

• Any error values, text, empty cells or logical values are not counted.

Examples

	Column1	Column2	Column3	Column4
Row1	Sales	4
Row2	23/8/2009	3
Row3
Row4	22
Row5	52.69			0
Row6	1
Row7	#DIV/0!

=COUNT(B2:B8)	Counts the number of cells that contain numbers in the list above (3)
=COUNT(B5:B8)	Counts the number of cells that contain numbers in the last 4 rows of the list (3)

---