Syntax :

=DMIN ( database, field, criteria )

Parameters :

• The following are the arguments:

Database :

• A set of cells that contains the database. The field names should be specified in the database’s top row.

Field :

• The database field (column) that you wish to have the bare minimum of. This can be a field number or the field name (i.e. the header in the top row of the database) surrounded by quotations (e.g. “Area”, “Quarter”, etc).

Criterion :

• A set of cells containing the criteria for determining which records should be included in the computation. The range can include one or more criteria, which are displayed in one cell as a field name and the condition for that field in the cell below.

E.g. :