Difference between revisions of "Manuals/calci/DCOUNTA"
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
*DCOUNT() can be used to count the number of cells from a list of database that are numbers and match a specified criteria. | *DCOUNT() can be used to count the number of cells from a list of database that are numbers and match a specified criteria. | ||
| − | |||
== Examples == | == Examples == | ||
| Line 98: | Line 97: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f " | '''Name''' |
| − | + | | class="sshl_f" | '''Age''' | |
| − | + | | class="sshl_f" | '''Salary''' | |
| − | | class=" | + | | class="sshl_f" | '''Age''' |
| − | | class=" " | | ||
| − | | class=" | ||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | |
| − | | class="sshl_f | + | | class="sshl_f" | <40 |
| − | | class="sshl_f" | | + | | class="sshl_f" | >5000 |
| − | | class=" | + | | class="sshl_fSelectTD SelectTD " | >32 |
| − | + | <div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div> | |
|- class="even" | |- class="even" | ||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | | class="sshl_f" | & | + | | class="sshl_f " | >30 |
| + | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f " | '''Name''' | |
| − | | class="sshl_f" | | + | | class="sshl_f" | '''Age''' |
| − | | class="sshl_f | + | | class="sshl_f" | '''Salary''' |
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="even" | |- class="even" | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class="sshl_f" | John | | class="sshl_f" | John | ||
| class="sshl_f" | 34 | | class="sshl_f" | 34 | ||
| class="sshl_f" | 5500 | | class="sshl_f" | 5500 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="odd" |
| − | |||
| class="sshl_f" | Bill | | class="sshl_f" | Bill | ||
| class="sshl_f" | 35 | | class="sshl_f" | 35 | ||
| class="sshl_f" | 6500 | | class="sshl_f" | 6500 | ||
| class="sshl_f " | | | class="sshl_f " | | ||
| − | |- class=" | + | |- class="even" |
| − | |||
| class="sshl_f" | Clark | | class="sshl_f" | Clark | ||
| class="sshl_f" | 29 | | class="sshl_f" | 29 | ||
| class="sshl_f" | 7000 | | class="sshl_f" | 7000 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="odd" |
| − | |||
| class="sshl_f" | Bob | | class="sshl_f" | Bob | ||
| class="sshl_f" | 45 | | class="sshl_f" | 45 | ||
| class="sshl_f" | 9000 | | class="sshl_f" | 9000 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="even" |
| − | |||
| class="sshl_f" | Susan | | class="sshl_f" | Susan | ||
| class="sshl_f" | 37 | | class="sshl_f" | 37 | ||
| class="sshl_f" | 4000 | | class="sshl_f" | 4000 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="odd" |
| − | |||
| class="sshl_f" | Jill | | class="sshl_f" | Jill | ||
| class="sshl_f" | 45 | | class="sshl_f" | 45 | ||
Revision as of 17:59, 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.
Examples
Consider the following table with Employee names, Age and Salary columns. Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.
| Name | Age | Salary | Age |
| <40 | >5000 | >32 | |
| >30 | |||
| Name | Age | Salary | |
| John | 34 | 5500 | |
| Bill | 35 | 6500 | |
| Clark | 29 | 7000 | |
| Bob | 45 | 9000 | |
| Susan | 37 | 4000 | |
| Jill | 45 | 8000 |
