Difference between revisions of "Manuals/calci/COUNT"
(→ZOS) |
|||
| Line 32: | Line 32: | ||
*The syntax is to calculate COUNT in ZOS is <math>COUNT(v1,v2,...)</math> | *The syntax is to calculate COUNT in ZOS is <math>COUNT(v1,v2,...)</math> | ||
**<math>v1, v2 ...</math> are the arguments. | **<math>v1, v2 ...</math> are the arguments. | ||
| − | + | *For e.g., COUNT(10,12,18,19,20,25) | |
| + | *COUNT(40..55) | ||
| + | *COUNT(120.5..150.5) | ||
== Examples == | == Examples == | ||
Revision as of 12:23, 4 June 2015
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
- are the arguments.
- For e.g., COUNT(10,12,18,19,20,25)
- COUNT(40..55)
- COUNT(120.5..150.5)
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. |