Excel DMIN Function
How to use the DMIN Function
This Excel tutorial explains how to use the Excel DMIN function with syntax and examples.
The Excel DMIN function returns the smallest number in a column of datatable or database, based on a given conditions.
- The formula =DMIN(D7:G14,"Price",D4:E5) would return 30000 numeric value.
- The formula =DMIN(D7:G14,2,D4:E5) would return 30000 numeric value.
To Get the minimum value in a column range based on given Criteria.
The DMIN function returns a Numeric value.
=DMIN(database, field, criteria)
The DMIN function syntax has the following arguments:
- database: Required. The range of cells that makes up the list or database including data headers.
- field: Required. The table header name or index number of header.
- criteria: Required. The range of cells that contains your criteria including data headers.
- The database argument is a range of cells that includes field headers.
- The criteria can include a variety of expressions, including some wildcards.
- The DMIN function supports wildcards in criteria.
- The Criteria can include more than one row.
- Make sure that the criteria range does not overlap the database list.
- The database and criteria ranges must include matching headers.