Difference between revisions of "Manuals/calci/COUNT"
| Line 1: | Line 1: | ||
| − | =COUNT(V1, V2...) | + | =COUNT(V1, V2...)= |
*Where V1, V2 ... are the arguments. | *Where V1, V2 ... are the arguments. | ||
| Line 18: | Line 18: | ||
* Any error values, text, empty cells or logical values are not 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. | ||
<!-- | <!-- | ||
</div> | </div> | ||
Revision as of 16:26, 1 November 2013
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.
- 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.
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 | #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. |