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
Criteria
Syntax: =DMIN(I122:N133,N122,I135:N136)
Result:
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.
