Returns the smallest number in a field of records in a database that match the specified conditions.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
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)Risultato: 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.