DMIN

The DMIN function is used to return the smallest value in a database, based on specified criteria. It is handy for extracting the minimum value from a range of records that meet specific conditions within a database in Excel.

Syntax

=DMIN(Database, Field, Criteria)

Database A range of cells that make up the database inclusive of header rows and columns.
Field The column number or header name in the database from which to find the minimum value.
Criteria A range of cells specifying the conditions that must be met for the minimum value extraction.

About DMIN

When you're navigating vast datasets in Excel and in search of the smallest value that fits specific criteria, lean on the DMIN function. It acts as a reliable tool for pinpointing the minimum value within a database based on designated conditions, catering to your data analysis needs with precision and efficiency. DMIN streamlines the process by allowing you to focus solely on the data that matters, zeroing in on the smallest figure that meets your defined criteria and facilitating swift decision-making in Excel's sea of information.

Examples

Consider a database containing sales records with columns like 'Product', 'Date', and 'Sales Amount'. You want to find the smallest sales amount for products sold between January 1, 2022, and June 30, 2022. The DMIN formula would be like this assuming the 'Sales Amount' is in column 3 and the database is from A1 to C100:

=DMIN(A1:C100, 'Sales Amount', A1:C100)

Imagine you have a database of student scores with columns like 'Name', 'Subject', and 'Score'. You aim to determine the lowest score for a specific subject like 'Math'. The DMIN function would help in extracting the minimum score for 'Math' from the dataset; supposing 'Subject' is in column 2 and the database range is from A1 to C50:

=DMIN(A1:C50, 'Score', A1:C50)

Questions

How does the DMIN function locate the smallest value in a database?

The DMIN function finds the smallest value in a database by evaluating the specified criteria and identifying the record that meets these conditions while yielding the minimum value in the chosen field.

Can the DMIN function handle databases with multiple criteria?

Yes, the DMIN function can manage databases with multiple criteria by assisting in the extraction of the smallest value that corresponds to the combined conditions specified within the dataset.

What happens if the criteria provided in the DMIN function do not match any records in the database?

If the criteria set in the DMIN function do not match any records in the database, the function will return a #NUM! error, indicating that no data satisfies the specified conditions for extracting the smallest value.

Related functions

DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP