Description Uses specified criteria to select records from a database, then displays the lowest number value found in a specified field of the selected records.
Note This is a database function, which has specific requirements that are different from most functions. For information and expanded argument descriptions, see "Database Functions".
Syntax DMIN ( database, field, criteria)
Argument | Description |
---|---|
database | A reference to a range containing data that the function searches. |
field | The column within database that contains the minimum value you want to find. |
criteria | A reference to a range containing search criteria. |
Remarks If there are no numeric values in field in the selected records, DMIN will display 0.
Examples This example uses the example database and criteria ranges shown in "Database Functions". This function returns 10320:
DMIN(A1:D8,"Commissions 96",B10:B11)
See Also DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP