DCOUNT in Excel is a handy formula that can count items based on a set of criteria. The criteria can be quite general, including matching words, specifying numerical bounds, and many other possibilities.
Syntax: =DCOUNT( range, [field], criteria )
The DCOUNT function syntax has the following arguments:
- range: The range of cells that you want to apply the criteria against.
- field (Optional): It is the column to count the numeric values that meet the criteria. You can either specify the numerical position of the column in the list or the column label in double quotation marks. If field is omitted, it will count all records that match the criteria.
- criteria: The range of cells that contains your criteria.
Example: Let’s look at some Excel DCOUNT function examples and explore how to use the DCOUNT function as a worksheet function in Microsoft Excel:
Syntax: =DCOUNT(A7:D14,B7,B16:B17)
Result:
Based on the Excel spreadsheet above, the following DCOUNT examples would return:
Syntax: =DCOUNT(A7:D14,C7,C16:C17)
Result: 4
Syntax: =DCOUNT(A7:D14,D7,D16:D17)
Result: 2
Note: The Excel DCOUNT function counts matching records in a database using a specified field and criteria. The database argument is a range of cells that includes field headers, field is the name or index of the field to count, and criteria is a range of cells with headers matching those in database.