writer
2,661
edits
Changes
no edit summary
=DCOUNT(db, fld, cri)=
=DCOUNT(database, field, criteria)=
*Where 'db' is the range of cells that makes up the list or database
*Where 'database' is the range of cells that makes up the list or database
*'fld' shows which column is used in the function and
*'field' shows which column is used in the function and
*'cri' is the range of cells that contains the specified criteria.
*'criteria' 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.
*DCOUNT() counts the numbers in the column of a list or database that match the specified criteria.
== Description ==
== Description ==
DCOUNT(db, fld, cri)
DCOUNT(database, field, criteria)
It counts the cells that contain numbers in a listed column or database that match the specified condition.
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.
*The argument 'field' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
* A 'column name' in quotes (e.g. "Salary") or 'column number' (e.g. 3, if Salary is 3rd column) can be used as 'fld' argument.
* A 'column name' in quotes (e.g. "Salary") or 'column number' (e.g. 3, if Salary is 3rd column) can be used as 'field' argument.
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.