DMIN
Returns the minimum value from selected database entries.
DatabaseDatabase & Lists
What it does
Finds the smallest number in a database column that matches criteria.
Syntax
DMIN(database, field, criteria)
Arguments
database(range) — The database range.field(text) — The column label.criteria(range) — The criteria range.
Examples
Min Cost
Find min cost for 'Parts'.
FORMULA
=DMIN(A1:B5, "Cost", D1:D2)
RESULT
50
SAMPLE DATA
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Type | Cost | Type | |
| 2 | Parts | 100 | ||
| 3 | Service | 200 | ||
| 4 | Parts | 50 | ||
| 5 | Parts | 150 | ||
| 6 | Parts |