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.

COUNT(1..100) returns 100 as a result.

COUNT(1..100,5,TRUE,"ONE") returns 102 as a result. Logical value 'TRUE' is not counted.

• 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.

• COUNTA() can be used to count the number of cells with empty text("") or error values.

• COUNTIF() can be used to count the number of cells that satisfy the given criteria.

ZOS

• The syntax is to calculate COUNT in ZOS is $COUNT(v1,v2,...)$
  • $v1,v2...$   are the arguments.

Examples

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

Sales	4
23/8/2009	3
			0
22
52.69			0
1
#NUM!

=COUNT(A1:A5)	Counts the number of cells that contain numbers in the cells A1 to A5, returns 3 as a result.
=COUNT(A4:A7)	Counts the number of cells that contain numbers in the cells A4 to A7, returns 3 as a result.
=COUNT(C5:C7)	Counts the number of cells that contain numbers in the cells C5 to C7, returns 0 as a result. COUNT() ignores the empty cells.
=COUNT(D1:D4,2)	Counts the number of cells that contain numbers in the cells D1 to D4, returns 2 as a result.

Related Videos

COUNT

See Also

• COUNTA

• COUNTIF

References

• List of Aggregate Functions
• COUNT