writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''DCOUNT'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''db'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,fld,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''cri'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where db '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">is the range of cells that makes up the list or database,</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">fld shows which column is used in the function and </font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">cri is the range of cells that contains the conditions that we specify. </font></font></font>+ − <br /><br />+ + + + + − + − − <div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">It counts the cells that contain numbers in a column of a list or database that match conditions we specify.</font></font></font></div> Line 73:
Line 75: − </div>+ − ----+ − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></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> − ----
no edit summary
=DCOUNT(db, fld, cri)=
*Where db is the range of cells that makes up the list or database
*'fld' shows which column is used in the function and
*'cri' is the range of cells that contains the conditions that we specify.
== Description ==
DCOUNT(db, fld, cri)
It counts the cells that contain numbers in a column of a list or database that match conditions we specify.
</div>
<!--
----
----
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
<br /><br />
<br /><br />
-->
<div id="2SpaceContent" class="zcontent" align="left">
<div id="2SpaceContent" class="zcontent" align="left">