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