=DMIN(database, field, criteria)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single DMIN formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
database:
The range of cells that contains the data you want to analyze. This range must include the field names in the first row.
field:
The column label or index number that specifies which column's data you want to extract the minimum value from. This can be a text string representing the column header or a number indicating the column's position in the database.
criteria:
The range of cells that defines the conditions that must be met for the data to be included in the calculation. This range should include at least one column label and one cell below it that specifies the condition.
The DMIN function in Excel is a useful tool that allows you to find the minimum value from a set of data based on specific criteria. It evaluates a database or a range of cells, checks each record against the specified criteria, and returns the smallest value from the selected field if the criteria are met.
In simpler terms, the DMIN function helps you identify the lowest value in a dataset that meets certain conditions, making it easier to analyze data.
Imagine you are managing a student database for a school, and you have the following data in an Excel spreadsheet:
| Name | Score | Grade |
|---|---|---|
| Alice | 85 | A |
| Bob | 70 | B |
| Charlie | 90 | A |
| David | 60 | C |
| Eve | 75 | B |
You want to find the minimum score of students who received an "A" grade.
To calculate the minimum score for students with an "A" grade, you would use the DMIN formula as follows:
=DMIN(A1:C6, "Score", E1:E2)When you apply the formula, it checks the scores of Alice and Charlie, who both received an "A" grade. The output would be:
| Minimum Score for Grade A |
|---|
| 85 |
Here, the minimum score among the students with an "A" grade is 85 (Alice).
The DMIN function is particularly useful when you need to analyze data based on specific conditions without manually filtering or sorting your data. It allows you to quickly identify the lowest values that meet your criteria, enhancing your data analysis capabilities.
Understanding how to use the DMIN function can significantly enhance your data analysis capabilities in Excel, enabling you to extract meaningful insights from your datasets.
Happy calculating!
You have a database where Column A contains product categories, Column B contains product names, and Column C contains prices. You can use the DMIN function to find the minimum price of a specific product category. This helps in identifying the lowest-priced item within that category, which can be useful for pricing strategies, inventory management, and promotional planning without needing to manually sift through the data.
Beyond the DMIN function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.