Returns the smallest number in a field of records in a database that match the specified conditions.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
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)Résultat : 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.