Difference between revisions of "Manuals/calci/DCOUNT"
Jump to navigation
Jump to search
| Line 93: | Line 93: | ||
| class="sshl_f" | '''Age''' | | class="sshl_f" | '''Age''' | ||
| class="sshl_f" | '''Salary''' | | class="sshl_f" | '''Salary''' | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | '''Age''' |
|- class="odd" | |- class="odd" | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | <30 | | class="sshl_f" | <30 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | | class="sshl_fSelectTD SelectTD " | | + | | 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> | <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" | ||
Revision as of 10:32, 7 November 2013
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 specified criteria.
- DCOUNT() counts the numbers in the column of a list or database that match the specified criteria.
Description
DCOUNT(db, fld, cri)
It counts the cells that contain numbers in a listed column or database that match the specified condition.
- The argument 'fld' is optional. If not mentioned, the function counts all the numbers from database that match the 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 |
| <30 | >32 | ||
| >40 | >5000 | ||
| Name | Age | Salary | |
| John | 34 | 5500 | |
| Bill | 35 | 6500 | |
| Clark | 29 | 7000 | |
| Bob | 45 | 9000 | |
| Susan | 37 | 4000 | |
| Jill | 45 | 8000 |
=DCOUNT(A4:C11,"Salary",A1:B2)
=DCOUNT(A4:C11,"Age","A1:C3")
=DCOUNT(A4:C11,"Salary",A1:C3,D2)