writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + Line 11:
Line 11: − + − +
no edit summary
=DCOUNT(database, field, criteria)=
<div style="font-size:30px">'''DCOUNT (Array,Field,Criteria)'''</div><br/>
*Where 'database' is the range of cells that makes up the list or database
*Where 'Array' is the range of cells that makes up the list or database
*'field' shows which column is used in the function and
*'Field' shows which column is used in the function and
*'criteria' 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(database, field, criteria)
DCOUNT (Array,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 'field' 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 'field' 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.