Difference between revisions of "Manuals/calci/DCOUNT"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=DCOUNT(db, fld, cri)= | =DCOUNT(db, fld, cri)= | ||
| − | *Where db is the range of cells that makes up the list or database | + | *Where 'db' is the range of cells that makes up the list or database |
*'fld' shows which column is used in the function and | *'fld' shows which column is used in the function and | ||
| − | *'cri' is the range of cells that contains the | + | *'cri' is the range of cells that contains the specified criteria. |
== Description == | == Description == | ||
| Line 11: | Line 11: | ||
DCOUNT(db, fld, cri) | DCOUNT(db, fld, cri) | ||
| − | It counts the cells that contain numbers in a column | + | It counts the cells that contain numbers in a listed column or database that match the specified condition. |
<!-- | <!-- | ||
Revision as of 17:51, 6 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.
Description
DCOUNT(db, fld, cri)
It counts the cells that contain numbers in a listed column or database that match the specified condition.
| 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 |