You can use the **DMIN **function in Excel to find the minimum value in a column that meet one or more specific conditions.

This function uses the following basic syntax:

**DMIN(database, field, criteria)**

where:

**database**: The range of cells that make up the “database” of interest**field**: The column to find minimum value in**criteria**: The range of cells that contain the conditions to meet

The following examples show how to use the **DMIN **function in practice with the following dataset in Excel that contains information about various basketball players:

**Example 1: Use DMIN with One Condition**

Suppose we would like to find the minimum value in the “Points” column where the value in the “Team” column is Mavs.

We can type our criteria into the range **A2:D3** and then use the following formula with the **DMIN **function in cell **G2**:

=DMIN(A5:D16, "Points", A2:D3)

The following screenshot shows how to use this formula in practice:

The formula returns a value of **20**.

This tells us that the minimum value in the “Points” column where the corresponding value in the “Team” column is Mavs is **20**.

**Example 2: Use DMIN with Multiple Conditions**

Suppose we would like to find the minimum value in the the “Rebounds” column where the following conditions are met:

- Value in “Team” column is Mavs
- Value in “Points” column is greater than 20

We can type our criteria into the range **A2:D3** and then use the following formula with the **DMIN **function in cell **G2**:

=DMIN(A5:D16, "Rebounds", A2:D3)

The following screenshot shows how to use this formula in practice:

The formula returns a value of **2**.

This tells us that the minimum value in the “Rebounds” column among players on the Mavs team with a points value greater than 20 is **2**.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

Excel: How to Use VLOOKUP to Return Minimum Value

Excel: Formula for Minimum IF Multiple Criteria

Excel: How to Use MIN Function and Exclude Zero