writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 13:
Line 13: − + Line 22:
Line 22: − <!--+ − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">COUNT</div></div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − --> + + − | class=" " | − <div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | class=" " | Column1 − | class=" " | Column2 − | class=" " | Column3 − | class=" " | Column4 − |- class="odd" − | class=" " | Row1 − + − | class=" " | Row2 − + − | Row3 Line 66:
Line 45: − + − | Row4 − + − | class=" " | Row5 − + − | class="sshl_f" | Row6 − + − | class="sshl_f" | Row7 Line 91:
Line 66: − <!--+ − <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> − ---- − -->
no edit summary
Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result.
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(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.
* COUNTIF() can be used to count the number of cells that satisfy the given criteria.
* COUNTIF() can be used to count the number of cells that satisfy the given criteria.
== Examples ==
== Examples ==
For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns.
For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns.
<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"
| class="sshl_f" | Sales
| class="sshl_f" | Sales
| class="sshl_f" | 4
| class="sshl_f" | 4
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="odd"
| class="sshl_f" | 23/8/2009
| class="sshl_f" | 23/8/2009
| class="sshl_f" | 3
| class="sshl_f" | 3
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_fSelectTD SelectTD " |
| class="sshl_fSelectTD SelectTD " |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" | 0
| class="sshl_f" | 0
|- class="even"
|- class="odd"
| class="sshl_f" | 22
| class="sshl_f" | 22
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" | 52.69
| class="sshl_f" | 52.69
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| 0
| 0
|- class="even"
|- class="odd"
| class="sshl_f" | 1
| class="sshl_f" | 1
| class="sshl_f " |
| class="sshl_f " |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f " | #NUM!
| class="sshl_f " | #NUM!
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|}
|}
<div id="5SpaceContent" class="zcontent" align="left">
<div id="5SpaceContent" class="zcontent" align="left">