Returns the smallest number in a field of records in a database that match the specified conditions.
Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.
DMIN(database, field, criteria)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)Resultat: 150
Finds the minimum value in the 'Price' column for records that match the criteria defined in E1:E2.
Yes, you can add multiple rows to your criteria range to create 'OR' logic or multiple columns for 'AND' logic.