writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 21:
Line 21: − <!--+ − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">COUNTA</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> − ---- − --> + + Line 82:
Line 71: − <!--+ − <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
* 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 COUNTA() function, consider the below table that contains different types of data in various columns.
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">
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
| class="sshl_f" |
| class="sshl_f" |
|}
|}
<div id="5SpaceContent" class="zcontent" align="left">
<div id="5SpaceContent" class="zcontent" align="left">
=COUNTA(A1:A7) : Counts the number of cells that contain numbers in the cells A1 to A7, ''returns 6'' as a result.
=COUNTA(A1:A7) : Counts the number of cells that contain numbers in the cells A1 to A7, ''returns 6'' as a result.
=COUNTA(A4:A7, 2) : Counts the number of cells that contain numbers in the cells A4 to A7 and number '2', ''returns 5'' as a result.
=COUNTA(A4:A7, 2) : Counts the number of cells that contain numbers in the cells A4 to A7 and number '2', ''returns 5'' as a result.
=COUNTA(B1:B5,"A",11) : Counts the number of cells that contain numbers in the cells B1 to B5 , text value "A" and number '11', ''returns 4'' as a result.
=COUNTA(B1:B5,"A",11) : Counts the number of cells that contain numbers in the cells B1 to B5 , text value "A" and number '11', ''returns 4'' as a result.