writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 11:
Line 11: − + + + Line 30:
Line 32: + Line 83:
Line 86: − + +
no edit summary
COUNT(V1,V2...)
COUNT(V1,V2...)
Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 5'' 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.
* 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.
----
----
-->
-->
== 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"
| 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">