Difference between revisions of "Manuals/calci/DCOUNTA"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''DCOUNTA'''</font></font></font><font color="...") |
|||
| Line 1: | Line 1: | ||
| − | + | =DCOUNTA(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 specified criteria. | |
| − | + | *DCOUNTA() counts the non-blank cells in the column of a list or database that match the specified criteria. | |
| − | </ | + | == Description == |
| − | + | ||
| − | + | DCOUNTA(db, fld, cri) | |
| + | |||
| + | It counts the nonblank cells in a column of a list or database that match conditions that we specify.</font></font></font> | ||
| + | |||
| + | *The argument 'fld' is optional. If not mentioned, the function counts all the numbers from database that match the criteria. | ||
| − | + | *Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition. | |
| − | + | *The Criteria columns should not overlap the list of data. | |
| − | |||
| − | |||
| − | + | *DCOUNT() can be used to count the number of cells from a list of database that are numbers and match a specified criteria. | |
| − | < | + | <!-- |
| − | |||
<div id="8SpaceContent" class="zcontent" align="left"> | <div id="8SpaceContent" class="zcontent" align="left"> | ||
| Line 76: | Line 77: | ||
</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="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> | ||
| Line 83: | Line 87: | ||
<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> | ||
---- | ---- | ||
| + | --> | ||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
Revision as of 18:55, 7 November 2013
DCOUNTA(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 specified criteria.
- DCOUNTA() counts the non-blank cells in the column of a list or database that match the specified criteria.
Description
DCOUNTA(db, fld, cri)
It counts the nonblank cells in a column of a list or database that match conditions that we specify.
- The argument 'fld' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
- Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
- The Criteria columns should not overlap the list of data.
- DCOUNT() can be used to count the number of cells from a list of database that are numbers and match a specified criteria.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Name | Age | Salary | 3 |
| Row2 | <30 | |||
| Row3 | >40 | >5000 | ||
| Row4 | Name | Age | Salary | |
| Row5 | John | 34 | 5500 | |
| Row6 | Bill | 35 | 6500 | |
| Row7 | Clark | 29 | 7000 | |
| Row8 | Bob | 45 | 9000 | |
| Row9 | Susan | 37 | 4000 | |
| Row10 | Jill | 45 | 8000 |
