EXCEL DCOUNT

The DCOUNT is an Excel function to count cells in a range that meets specified criteria.

Syntax:

= DCOUNT(database,field,criteria)

Arguments or Parameters:

database: The range of cells that you want to apply criteria against.
field [optional]: column to count the numeric values that meet the criteria.
criteria: The range of cells that meet the criteria

Objective: Find the count of cells where quantity is greater then 2

Step 1:

Type = sign in cell I5.
Type DCOUNT Function

Step 2:

Select range A2:F22
Type “,”

Step 3:

Type F2
Type “,”

Step 4:

Select range H2:K3
Type “,”
Close the Bracket “)”
Press Enter

Result: The DCount Function has counted 8 cells in cell I5 where Qty is greater than 2.