Difference between revisions of "Manuals/calci/COUNT"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
*COUNT() returns the number of cells that contain numbers within the list of arguments. | *COUNT() returns the number of cells that contain numbers within the list of arguments. | ||
| − | *Arguments can be numbers, dates or text | + | *Arguments can be numbers, dates or text representation of numbers. |
| − | *Logical values | + | *Logical values, text, error values are ignored. |
== Description == | == Description == | ||
| + | COUNT(V1,V2...) | ||
| + | |||
| + | Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 5'' 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. | ||
<!-- | <!-- | ||
</div> | </div> | ||
Revision as of 14:57, 1 November 2013
=COUNT(V1, V2...)
- Where V1, V2 ... are the arguments
- COUNT() returns the number of cells that contain 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 5 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.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Sales | 4 | ||
| Row2 | 23/8/2009 | 3 | ||
| Row3 | ||||
| Row4 | 22 | |||
| Row5 | 52.69 | 0 | ||
| Row6 | 1 | |||
| Row7 | #DIV/0! |
AVEDEV (N1, N2...) Where N1, N 2 ... are positive integers.
|
=COUNT(B2:B8) |
Counts the number of cells that contain numbers in the list above (3) |
|
=COUNT(B5:B8) |
Counts the number of cells that contain numbers in the last 4 rows of the list (3) |