| Line 1: |
Line 1: |
| − | =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. |
| Line 11: |
Line 11: |
| | == 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. |