Step1
Learn the syntax of DMIN. It is DMIN(database, field, criteria). Database is an array that specifies the database, field is the column name or number in the database from which DMIN will take values and criteria is a cell range that contains the criteria to be used in selecting the rows.
Step2
Enter the following in the first four columns of an Excel spreadsheet:
Row 1: Tree, Height, Age and Yield;
Row 2: ="=Apple" and =">14" (nothing in columns three and four);
Row 3: Tree, Height, Age and Yield;
Row 4: Apple, 18, 20 and 14;
Row 5: Pear, 12, 12 and 10;
Row 6: Cherry, 13, 14 and 9;
Row 7: Apple, 14, 15 and 10;
Row 8: Pear, 9, 8 and 8;
Row 9: Apple, 8, 9 and 6.
Step3
Interpret the formula =DMIN(A3:D9,"Height",A1:B2) as follows: The database is defined by the array A3:D9. Note the column names in the first row of this array. "Height" is the column name from which the values will be taken. The criteria are given by A1:B2, which indicates that the column named Tree must contain "Apple" and the column named Height must contain a value greater than 14.
Step4
Evaluate DMIN(A3:D9,"Age",A1:B2) as MIN(18,14). In this example, DMIN will return 14.
