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

For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns.

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

=COUNT(A1:A5)	Counts the number of cells that contain numbers in the cells A1 to A5. Gives result 3
COUNT(C5:C7)	Counts the number of cells that contain numbers in the last 4 rows of the list (3)

---