How to Use the DMIN Function in Excel
Today, we’ll delve into the DMIN function, available in both Microsoft Excel and Google Sheets. The DMIN function, short for “Database Minimum,” is designed to identify the smallest value within a specific column of a database that meets designated criteria.
Understanding the DMIN Function
The syntax for the DMIN function is as follows:
DMIN(database, field, criteria)database: Defines the cell range that constitutes the database.field: Specifies the column or row that contains the values from which the minimum will be calculated.criteria: The range of cells defining the conditions to be met.
Examples of using DMIN
Consider a database with information on student grades, and we need to ascertain the lowest grade for students who achieved more than 80 points in a particular subject. For instance:
| Student | Subject | Grade |
|---|---|---|
| 1 | Math | 85 |
| 2 | Math | 76 |
| 3 | Math | 90 |
To find the minimum grade for students scoring over 80 in Math, the formula would be:
=DMIN(A1:C4, "Grade", A8:B9)A1:C4indicates the entire database range."Grade"points to the column containing the grades.A8:B9covers the criteria range, stipulating that the subject is Math and the grade is above 80.
This formula, once executed, returns the minimum grade for students who scored over 80 in Math.
Conclusion
The DMIN function is an invaluable resource for extracting the minimum values from a database under specified conditions in both Excel and Google Sheets. It allows users to gain meaningful insights from data efficiently.
More information: https://support.microsoft.com/en-us/office/dmin-function-4ae6f1d9-1f26-40f1-a783-6dc3680192a3