# Google Sheets DMIN Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/dmin-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The DMIN function returns the smallest value from a specified column in a database that meets given criteria. ``` DMIN(database, field, criteria) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the DMIN you need in plain EnglishGenerate Formula ## Parameters **`database`**:\ The range of cells that contains the data you want to analyze. This range should include the headers for the fields. **`field`**:\ The specific column or field from which you want to extract the minimum value. This can be the column header name (as a string) or the index number of the column (starting from 1 for the first column in the database). **`criteria`**:\ The range of cells that defines the conditions that must be met for a record to be included in the calculation. This range should include at least one column header and one cell below it that specifies the condition. ## What is a DMIN? The *DMIN* function in Google Sheets is a database function that returns the minimum value from a specified column in a database that meets certain criteria. This function is particularly useful when you need to analyze data in a structured format, such as tables, and want to find the lowest value based on specific conditions. In simpler terms, DMIN allows you to filter your data based on certain criteria and then find the smallest value in a particular column of that filtered data. ## A Practical Example Imagine you are managing a database of employee salaries stored in a Google Sheets spreadsheet: ### Employee Table: | EmployeeID | Name | Department | Salary | | - | - | - | - | | 1 | John Doe | Sales | 50000 | | 2 | Jane Smith | Marketing | 60000 | | 3 | Jim Brown | Sales | 45000 | | 4 | Jake White | HR | 70000 | You want to find the minimum salary of employees in the Sales department. ## DMIN Formula To achieve this, you would use the DMIN function as follows: ``` =DMIN(A1:D5, "Salary", A7:B8) ``` In this formula: - `A1:D5` is the range of the entire database (the Employee Table). - `"Salary"` is the column from which you want to find the minimum value. - `A7:B8` is the range that contains the criteria for filtering the data. ### Criteria Table: | Department | Value | | - | - | | Sales | | ## Result of the Formula When you apply the DMIN formula with the criteria set for the Sales department, the output would be: ``` 45000 ``` This indicates that the minimum salary of employees in the Sales department is $45,000. ## Why Use DMIN? DMIN is beneficial because it allows for efficient data analysis within structured datasets. It simplifies the process of finding minimum values based on specific criteria without the need for complex filtering or sorting. This makes it an essential tool for anyone working with databases in Google Sheets. ## Key Takeaways: - **DMIN**: A Google Sheets function that returns the minimum value from a specified column based on given criteria. - **Structured Data**: Ideal for analyzing data in tables or databases. - **Criteria-Based**: Allows you to filter data based on specific conditions before calculating the minimum value. - **Common Use Cases**: Useful for salary analysis, inventory management, and any scenario where minimum value retrieval based on conditions is necessary. DMIN is an essential function for anyone working with data in Google Sheets, providing a powerful way to enhance data analysis and reporting capabilities. Happy spreadsheeting! ## Example use case You have a sales database with columns for product names and their prices. Using the DMIN formula, you can find the minimum price of a specific product category, enabling quick analysis of pricing strategies and helping to identify competitive pricing opportunities. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) - [How To Merge Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-merge-cells-in-google-sheets) - [How To Multiply In Google Sheets](https://betteranalyst.com/google-sheets/how-to-multiply-in-google-sheets) - [How To Password Protect An Google Sheets File](https://betteranalyst.com/google-sheets/how-to-password-protect-an-google-sheets-file) - [How To Remove Blank Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-blank-rows-in-google-sheets) - [How To Remove Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-duplicates-in-google-sheets) - [How To Separate Names In Google Sheets](https://betteranalyst.com/google-sheets/how-to-separate-names-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.