Difference between revisions of "Manuals/calci/COUNT"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
COUNT(V1,V2...) | COUNT(V1,V2...) | ||
| − | Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns | + | 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. | * The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted. | ||
| Line 30: | Line 32: | ||
---- | ---- | ||
--> | --> | ||
| + | == Examples == | ||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
| Line 83: | Line 86: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
| − | + | <!-- | |
<div align="left">[[Image:calci1.gif]]</div></div> | <div align="left">[[Image:calci1.gif]]</div></div> | ||
---- | ---- | ||
<div id="8SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">AVEDEV (N1, N2...)</font></font> <font size="3"><font face="Times New Roman">Where N1, N 2 ... are positive integers.</font></font> '''</font></font></div> | <div id="8SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">AVEDEV (N1, N2...)</font></font> <font size="3"><font face="Times New Roman">Where N1, N 2 ... are positive integers.</font></font> '''</font></font></div> | ||
---- | ---- | ||
| + | --> | ||
<div id="5SpaceContent" class="zcontent" align="left"> | <div id="5SpaceContent" class="zcontent" align="left"> | ||
Revision as of 16:14, 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.
Examples
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Sales | 4 | ||
| Row2 | 23/8/2009 | 3 | ||
| Row3 | ||||
| Row4 | 22 | |||
| Row5 | 52.69 | 0 | ||
| Row6 | 1 | |||
| Row7 | #DIV/0! |
|
=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) |