DMIN

Returns the smallest number in a column of cell range which matches the specified criteria.

Syntax

=DMIN(DataRange, ColumnIndex, CriteriaRange)

Arguments

Name

Description

DataRange

Cell range, that containes the data to evaluate. The range must include the field labels.

ColumnIndex

Column label or index to find the minimum value in.

CriteriaRange

Specifies the conditions a row in cell range must fulfill. Must define at least one column with a label and a cell below which specifies the condition.

Return Value

The minimum value of the matching column.

Example

Function

Result

Comment

=DMIN(A5:C9,2,A2:C3)

DSUM

19

Evaluates the minimum age in “Berlin”.