How do I use the DMIN function in Excel?

By /

The DMIN function in Excel is a mathematical formula that allows users to find the minimum value in a specified range of cells within a dataset. To use the DMIN function, first select the cell where the result will be displayed. Then, type “=DMIN(” into the formula bar followed by the range of cells and criteria for the minimum value. Press Enter to calculate the result. This function is useful for quickly finding the lowest value in a large dataset and can be used in various scenarios, such as financial analysis, data comparison, and statistical analysis.

Use DMIN Function in Excel (With Examples)

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:

Excel DMIN function example

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:

x

Related terms:

  1. How can I use the INDIRECT function with the SUM function in Excel?
  2. How can I use the IF Function with the LEFT Function in Microsoft Excel?
  3. The SUBSTR Function in SAS (With Examples) How to use the SUBSTR function in SAS?
  4. How can I use the VSTACK function in Excel to ignore blanks?
  5. How can I use the NOW function in Excel to return only the date?
  6. How can I use the AVERAGEIFS function in Excel with an OR condition?
  7. How can I use an IF function with 2 conditions in Excel?
  8. How can I use the IF function in Excel to return either net income or net loss?
  9. How can I use the SUMIF function with a horizontal range in Excel?
  10. How can I use the DMAX function in Excel and what are some examples of its usage?