DCOUNT
Get the number of cells in database field that contain numbers that satisfy the criteria.
You can download the sample file (Database.cell) to practice functions.
Formula> =DCOUNT(database,field,criteria)
- database: range of cell references containing the database that includes the field names
- field: field name in double quotation marks or column number
- criteria: range of cells that contains the conditions you specify
Steps
- Select the cell in which you want the result to appear.
- Click the Function Wizard
icon on the formula bar to open the Function Wizard dialog box.
- Click the OK button on the Function Wizard dialog box.
- Select Database from the Function Classification list and then select DCOUNT from the Function Name list.
- Specify the range of cell references in the Database box, the field name or the column number in the Field box, and the range of the cells containing your criteria in the Criteria box on the Function Argument dialog box.
- Click the OK button on the Function Argument dialog box.
Note
Argument Tip
If you click on each of the argument boxes of the Function Argument dialog box, each of the argument descriptions appears at the bottom of the dialog box.