How to use the Excel DMIN function

DMIN function is built-in database function in Excel. The DMIN function returns the MINIMUM of the values from the database having multiple conditions. Conditions to the function is given using a table, which must have the same fields or headers as on the database.

Syntax: =DMIN(database, field, criteria)

The DMIN function syntax has the following arguments:

  • database: The range of cells that make up the database or list.
  • field: The column name or number indicating which column to use.
  • criteria: The range of cells that contain the conditions.

Example: Let’s look at some Excel DMIN function examples and explore how to use the DMIN function as a worksheet function in Microsoft Excel:

Database

Excel DMIN function - How to use the Excel DMIN function

Criteria

DMIN function - How to use the Excel DMIN function

Syntax:  =DMIN(I122:N133,N122,I135:N136)

Result:

Excel DMIN function 1 - How to use the Excel DMIN function

Based on the Excel spreadsheet above, the following DMIN examples would return:

City: Florida 
Category: Cookies
Result: 38

City: Oregon
Category: Bars
Result: 42.24

Category: Cookies
Product: Chocolate Chip
Result: 38

Product: Arrowroot
Result: 35.87

Note: The Excel DMAX function gets the minimum value in a given field from a set of records that match criteria. The database argument is a range of cells that includes field headers, field is the name or index of the field to get a max value from, and criteria is a range of cells with headers that match those in database.

Add a Comment

Your email address will not be published. Required fields are marked *