DCOUNT Excel Function

The DCOUNT function counts the numeric values from the database that fulfills the set criteria. Like the COUNT function that returns the count of numeric values, the DCOUNT function also returns the count of values. However, the DCOUNT() checks for the criteria and then counts the cells that meet the criteria.

The syntax of the DCOUNT function is =DCOUNT(database,field,criteria)

We can insert the DCOUNT function as follows:
1. Select an empty cell for the output.
2. Type =DCOUNT( in the selected cell. [Alternatively, type =D or =DC and double-click the DCOUNT function from the list of suggestions shown by Excel.
3. Enter the arguments as cell values or cell references and close the brackets.
4. Press the “Enter” key.

For example, we will calculate the output by counting numeric values using the DCOUNT function.

In the table, the data is,
• Column A contains the Value.
• Column B displays the Output.



The procedure to calculate the value using the DCOUNT formula is,
Select cell B2, enter the formula =DCOUNT(A1:A5,A1,A2:A5), and press the “Enter” key.
[Note: The value of ‘database’ is A1:A5, ‘field’ is A1, and ‘criteria’ is A2:A5.]



The result is “3”, as shown above.

The DCOUNT function is found in the “Formulas” tab, as shown below.

Choose an empty cell for the output → select the “Formulas” tab → click the “Insert Function” group, as shown below.



The “Insert Function” window appears. Now, choose the “Database” option from the “select a category:” drop-down.



Then, select the “DCOUNT” function from the “Select a function:” group → and click “OK”, as shown below.