writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left">+ − <font size="3"><font face="Times New Roman">COUNTA (V1, V2...)</font></font>+ − <font size="3"><font face="Times New Roman">Where V1, V2…. are arguments.</font></font>+ − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − − <font size="3"><font face="Times New Roman">It is to count the number of cells which contains data in a range. </font></font> − − </div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − <font size="3">·</font> <font size="3"><font face="Times New Roman">It does not include empty cells but including error values and empty text.</font></font>+ − <font size="3">·</font> <font size="3"><font face="Times New Roman">Empty cells and text values in the array or reference are ignored. </font></font>+ + + Line 31:
Line 25: + + + Line 59:
Line 56: − + Line 85:
Line 82: − + +
no edit summary
=COUNTA (V1, V2...)=
*Where V1, V2…. are arguments.
*It is used to count the number of cells which contains data in a range.
*It does not include empty cells but including error values and empty text.
*Empty cells and text values in the array or reference are ignored.
== Description ==
COUNTA(V1,V2....)
<!--
</div>
</div>
----
----
<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>
----
----
-->
== Examples ==
For better understanding of COUNTA() function, consider the below table that contains different types of data in various columns.
<div id="2SpaceContent" class="zcontent" align="left">
<div id="2SpaceContent" class="zcontent" align="left">
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |0
|- class="even"
|- class="even"
| Row4
| Row4
| 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">