DMIN

Formulas / DMIN
Calculate the minimum value in a field from a set of records that match specified criteria.
==DMIN(database,field,criteria)
  • Database - required, the range of cells that the function will operate on
  • Field - required, the column used in the function
  • Criteria - required, the range of cells with the conditions

Examples

  • =DMIN(B7:E14,"Price",B4:E5)

    The example uses the DMIN function to find the minimum value from the field "Price" from records where the color is "Red" and the quantity is greater than or equal to 2.

  • =DMIN(B7:E14,"Quantity",C4:E5)

    This example uses the DMIN function to find the minimum value from the field "Quantity" from records where the color is "Blue" and the price is greater than or equal to 10.

  • =DMIN(B7:E14,"Quantity",D4:E5)

    The preceding example uses the DMIN function to find the minimum value from the field "Quantity" from records where the color is "Green" and the price is greater than or equal to 5.

  • =DMIN(B7:E14,"Price",E4:E5)

    The example uses the DMIN function to find the minimum value from the field "Price" from records where the color is "Yellow" and the quantity is greater than or equal to 1.

  • =DMIN(B7:E14,"Quantity",B5:E5)

    This example uses the DMIN function to find the minimum value from the field "Quantity" from records where the color is "Orange" and the price is greater than or equal to 15.


Summary

The DMIN function is used to return the smallest number from a field in a list or database. It requires the database, field and criteria arguments and works by finding the smallest number in the field that meets the conditions specified in the criteria argument.

  • The DMIN function is a useful tool for finding the record with the minimum value in a field from a set of records that match criteria.
  • The DMIN function works well with multi-row criteria, allowing users to easily find the minimum value in a field from a set of records.

Frequently Asked Questions

What is the Sourcetable DMIN function?
The Sourcetable DMIN function returns the record with the minimum value in a field from a set of records that match the criteria.
What is the opposite of the DMIN function?
The opposite of the DMIN function is the MAX function, which returns the record with the maximum value in a field from a set of records that match the criteria.
How can I use the DMIN function?
You can use the DMIN function with a database argument that includes field headers, a field argument that specifies the field to get a min from, and a criteria argument that includes field headers.
What does DMAX do?
The DMAX function finds the minimum value in a field from a set of records that match criteria.
What arguments are needed to use the DMIN function?
  • Database argument that includes field headers
  • Field argument that specifies the field to get a min from
  • Criteria argument that includes field headers

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV