The DMIN function returns the minimum value in a field, from a set of records that match criteria. Use the MAX function to get the maximum value.
Purpose of Excel DMIN Function
Get min from matching records.
Return value
The minimum value in a given field.
Syntax
=DMIN (database, field, criteria)
Arguments
| Arguments | Description | Remarks |
| database | Database range including headers | Mandatory |
| field | Field name or index to count | Mandatory |
| criteria | Criteria range including headers | Mandatory |
Usage notes
- For example, if the range G1:G2 contains the column label Income in G1 and the amount $10,000 in G2, you could define the range as MatchIncome and use that name as the criteria argument in the database functions.
- Although the criteria range can be located anywhere on the worksheet, do not place the criteria range below the list.
- If you add more information to the list, the new information is added to the first row below the list.
- If the row below the list is not blank, Microsoft Excel cannot add the new information.
- Make sure that the criteria range does not overlap the list.
- To perform an operation on an entire column in a database, enter a blank line below the column labels in the criteria range.The field argument can be supplied as a name in double quotes (“”) or as a number representing field index.
Availability
Since 2007 for Windows.
Since 2011 for Mac.