Difference between revisions of "Manuals/calci/COUNT"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">'''COUNT''' (V1, V2...)</font></font> <font size="3"><font face="Times...") |
|||
| Line 1: | Line 1: | ||
| − | + | =COUNT(V1, V2...) | |
| + | *Where V1, V2 ... are the arguments | ||
| − | + | *COUNT returns the number of cells that contain numbers. | |
| − | + | *Arguments can be numbers, dates or text representations numbers that are counted. | |
| − | + | *Logical values and text representations of numbers are ignored | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | == Description == | ||
| + | <!-- | ||
</div> | </div> | ||
---- | ---- | ||
| Line 30: | Line 21: | ||
---- | ---- | ||
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> | <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> | ||
| − | ---- | + | ---- |
| + | --> | ||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
| − | |||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
Revision as of 15:36, 1 November 2013
=COUNT(V1, V2...)
- Where V1, V2 ... are the arguments
- COUNT returns the number of cells that contain numbers.
- Arguments can be numbers, dates or text representations numbers that are counted.
- Logical values and text representations of numbers are ignored
Description
| 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) |