Syntax:
DMIN(range, condition)
Returns the minimum value in the range for which the condition is satisfied.
Example:
DMIN(A1:C5, A1:C5>5 & A1:C5<70)
will return the smallest value from the range of cells A1
to C5
which is greater than 5
and smaller than 70
.
See DAVG
for more examples of how to use the condition to control which cells are included.