DMIN
TheDMIN
function returns the minimum value from a column in a database, based on a specified condition. This function is commonly used to extract specific data from large databases.
 How to use
DMIN
formula?  Examples of using
DMIN
formula DMIN
formula not working? Similar formulas to
DMIN
Usage
Use the DMIN
formula with the syntax shown below, it has 3 required parameters:
 database (required):
The range of cells that make up the database.  field (required):
The column or field from which to extract the minimum value.  criteria (required):
The range of cells that contains the conditions to be met.
Examples
Here are a few example use cases that explain how to use theDMIN
formula in Google Sheets.
Extracting the lowest score from a student database
Suppose you have a database of student scores and you want to extract the lowest score from a specific subject. You can use DMIN
to extract the lowest score that meets your criteria.
Extracting the earliest date from a database
If you have a large database with dates, you can use DMIN
to extract the earliest date that meets your criteria. This can be useful for inventory management or scheduling tasks.
Extracting the lowest price from a product database
If you have a database of products and their prices, you can use DMIN
to extract the lowest price for a specific product. This can be useful for comparing prices or finding the best deals.
Common Mistakes
DMIN
not working? Here are some common mistakes people make when using the DMIN
Google Sheets Formula:
Incorrect range for database
One common mistake is providing an incorrect range for the database argument. Ensure that the range includes all the data including the headers.
Incorrect field name
Another common mistake is providing an incorrect field name for the field argument. Ensure that the field name matches exactly with the header of the column in the database.
Incorrect criteria
A common mistake is providing an incorrect criteria for the criteria argument. Ensure that the criteria is in the same format as the data in the field you are trying to search.
Related Formulas
The following functions are similar to DMIN
or are often used with it in a formula:

DAVERAGE
The
DAVERAGE
function calculates the average value of a specified field in a database that matches the given criteria. The function is commonly used in financial and business analysis to calculate averages based on specific conditions. 
DCOUNT
The
DCOUNT
function is a database function in Google Sheets that counts the number of cells in a column of a database that match a set of criteria. This function is most commonly used to filter a database based on certain criteria and count the number of cells that meet that criteria. 
DMAX
The
DMAX
function is a Database function in Google Sheets that returns the maximum value of a single column in a database table that meets specified criteria. The criteria can be specified using multiple conditions. This function is commonly used in data analysis, especially when working with large datasets. 
DSUM
The
DSUM
function is a database function that calculates the sum of a set of values in a specified field, subject to the provided criteria. It is commonly used for filtering large data sets based on certain criteria and calculating the total sum of a particular field that matches the criteria.
Learn More
You can learn more about the DMIN
Google Sheets function on Google Support.