Changes

Manuals/calci/COUNT (view source)

Revision as of 21:14, 1 November 2013

71 bytes added , 21:14, 1 November 2013

no edit summary

Line 11: Line 11:

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.

Line 30: Line 32:

----

-->

+

== Examples ==

{| id="TABLE3" class="SpreadSheet blue"

Line 83: Line 86:

| class="sshl_f" |

|}

−

+

<!--

<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>

----

+

-->

Swapna

writer

2,661

edits