Functions
DMIN
Minimum field value for rows matching criteria
Try it
When to use it
When should I use DMIN?
Use DMIN to find the lowest value in a field among only the rows that match your criteria — useful for finding the minimum cost, lowest score, or smallest measurement within a filtered subset of a database table.
Used in
Syntax
DMIN(database, field, criteria)Examples
=DMIN({"Name","Score";"Alice",90;"Bob",80;"Carol",70},"Score",{"Score";">75"}) // => 80
=DMIN({"Cat","Val";"A",10;"A",30;"B",20},2,{"Cat";"A"}) // => 10
=DMIN({"G","V";"X",5;"X",15;"X",10},2,{"G";"X"}) // => 5