Excel Functions

Excel DMIN Function

Pinterest LinkedIn Tumblr

The DMIN function returns the minimum value in a field, from a set of records that match criteria. Use the MAX function to get the maximum value.

Purpose of Excel DMIN Function

Get min from matching records.

Return value

The minimum value in a given field.

Syntax

=DMIN (database, field, criteria)

Arguments

ArgumentsDescriptionRemarks
databaseDatabase range including headersMandatory
field Field name or index to count Mandatory
criteriaCriteria range including headers Mandatory

Usage notes

  • For example, if the range G1:G2 contains the column label Income in G1 and the amount $10,000 in G2, you could define the range as MatchIncome and use that name as the criteria argument in the database functions.
  • Although the criteria range can be located anywhere on the worksheet, do not place the criteria range below the list.
  • If you add more information to the list, the new information is added to the first row below the list.
  • If the row below the list is not blank, Microsoft Excel cannot add the new information.
  • Make sure that the criteria range does not overlap the list.
  • To perform an operation on an entire column in a database, enter a blank line below the column labels in the criteria range.The field argument can be supplied as a name in double quotes (“”) or as a number representing field index.

Availability

Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment