Returns the smallest number in a field of records in a database that match the specified conditions.
Składnia
DMIN(database, field, criteria)Argumenty
databasewymagane
The range of cells that makes up the list or database.
fieldwymagane
The column label or index number used in the function.
criteriawymagane
The range of cells that contains the conditions you specify.
The DMIN function evaluates a database table and extracts the minimum value from a specific column based on criteria you define. It is part of the database function family, which is useful for performing complex queries on structured data ranges.
=DMIN(A1:C10, "Price", E1:E2)→150Finds the minimum value in the 'Price' column for records that match the criteria defined in E1:E2.
Prepare your data
Ensure your database has headers and that your criteria range includes the same header name as the column you are filtering.
Enter the formula
Input the DMIN function, selecting the database range, the specific field name, and the criteria range.
Yes, you can add multiple rows to your criteria range to create 'OR' logic or multiple columns for 'AND' logic.