DMIN Google Sheets Formula

Generate Google Sheets DMIN Formulas in seconds

Interactive Google Sheets Formula Generator

Create complex Google Sheets formulas with natural language. Simply describe what you want to calculate.

Get advanced formulas, batch processing, and priority support

Your formula will be displayed here:

Your formula will appear here

Describe what you want to calculate and click Generate

Sheet Alchemy Pro includes additional advanced features to enhance your formula generation.

Complex array formulas and dynamic ranges

Generate multiple formulas at once

Save and organize all your formulas

=DMIN(A1:C5, "Score", A1:C2)

Finds the minimum value in a column of a database range based on criteria in Google Sheets.

The DMIN function returns the lowest numeric value in a specified column of a database range that meets given criteria.

DMIN is useful for identifying the smallest value in a dataset, like the lowest score or price under specific conditions.

Database	Criteria	Formula	Result
A1:C5 = {Name, Age, Score; "John", 25, 80; "Jane", 30, 90; "Bob", 25, 70; "Alice", 35, 85}	A1:C2 = {Name, Age, Score; "", 25, ""}	=DMIN(A1:C5, "Score", A1:C2)	70
A1:C4 = {Item, Qty, Price; "A", 10, 5; "B", 20, 10; "A", 15, 7}	A1:C2 = {Item, Qty, Price; "A", "", ""}	=DMIN(A1:C4, "Price", A1:C2)	5
A1:C3 = {Name, Age, Score; "Tom", 40, 95; "Sue", 30, 88}	A1:C2 = {Name, Age, Score; "", "", ">80"}	=DMIN(A1:C3, "Score", A1:C2)	88