| 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>
| + | =DCOUNT(db, fld, cri)= |
| | | | |
| − | <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>
| + | *Where db is the range of cells that makes up the list or database |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">fld shows which column is used in the function and </font></font></font>
| + | *'fld' shows which column is used in the function and |
| | | | |
| − | <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>
| + | *'cri' is the range of cells that contains the conditions that we specify. |
| | | | |
| − | <br /><br />
| + | == 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="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>
| |
| | ---- | | ---- |
| | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> | | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> |
| Line 73: |
Line 75: |
| | <br /><br /> | | <br /><br /> |
| | | | |
| − | </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>
| |
| − | ----
| |
| | <div id="2SpaceContent" class="zcontent" align="left"> | | <div id="2SpaceContent" class="zcontent" align="left"> |
| | | | |