DMIN
The DMIN function returns the smallest value in a database based on specified criteria. It extracts the minimum value from records that meet specific conditions within a database.
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 🔗
Use the DMIN function to find the smallest value in a database that meets specific criteria. This function helps you focus on relevant data by identifying the minimum value based on the conditions you set. It simplifies the process of analyzing large datasets in Excel, allowing you to make informed decisions efficiently.
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. You would use the DMIN formula 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 assist in extracting the minimum score for 'Math' from the dataset; suppose 'Subject' is in column 2 and the database range is from A1 to C50:
=DMIN(A1:C50, "Score", A1:C50)
Notes 🔗
To use the DMIN function effectively, specify the database range, field reference, and criteria range accurately. The function calculates the smallest value based on the conditions you define.
Questions 🔗
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