How to Use DMIN and DMAX Function in Excel + Tips (Video in Khmer)

Hello everyone! Today i will show you how to use DMIN and DMAX function in Excel step by step.

What is DMIN and DMAX Function in Excel?

The DMIN and DMAX functions are Database formulas in Microsoft Excel:

• DMIN: Help you find smallest (minimum) number in a column of table database that match criteria condition you set.
• DMAX: Help you find largest (maximum) number in a column of table database that match criteria condition you set.

Unlike standard MIN or MAX formulas, DMIN and DMAX use a separate criteria table header range, which make complex filtering and condition setup super easy!

📚 Related Tutorial: Want to add up numbers in database table instead? Check out How to Use DSUM Function in Excel!

🛠️ Formula Syntax

=DMIN(database, field, criteria)
=DMAX(database, field, criteria)

• database: The full range of cell table including header titles (example: A1:C6).
• field: Column header name in quotes (example: "Sales") or column index number (example: 3) you want to search min or max number.
• criteria: The cell range containing header titles and condition criteria (example: E1:F2).

📋 Sample Data Table (Follow Along)

To test DMIN and DMAX easily, create this main database table in range A1:C6:

Criteria Table Setup (Range E1:F2)

Create your criteria box in cell range E1:F2 with identical headers:

📊 Simple Examples

Example 1: DMIN - Find Lowest Sales in North Region

In criteria box E1:F2, put "North" under Region (Cell E2):

=DMIN(A1:C6, "Sales", E1:F2)

👉 Calculation: Compare North region sales (Sok: $500, Lina: $800, Sopheap: $400).
👉 Result: $400 (Lowest sale in North region from Sopheap).

Example 2: DMAX - Find Highest Sales in North Region

Using same criteria range E1:F2 (Region = North):

=DMAX(A1:C6, "Sales", E1:F2)

👉 Calculation: Compare North region sales (Sok: $500, Lina: $800, Sopheap: $400).
👉 Result: $800 (Highest sale in North region from Lina).

Example 3: DMIN with AND Condition (North Region AND Sales > 400)

Set Criteria Range E1:F2:

• Cell E2 (Region) = "North"
• Cell F2 (Sales) = ">400"

Formula:

=DMIN(A1:C6, "Sales", E1:F2)

👉 Result: $500 (Finds minimum sale in North that is greater than 400, matching Sok).

⚡ DMIN / DMAX vs MINIFS / MAXIFS Comparison

📹 Video Tutorials in Khmer

How to Use DMIN Function in Excel (Video in Khmer)

How to Use DMAX Function in Excel (Video in Khmer)

💡 Quick Tips for DMIN & DMAX Functions

1. Headers Must Match Exactly: Header titles in your criteria box (like "Region" or "Sales") must match main database headers exactly!
2. Avoid Empty Criteria Rows: If your criteria range selection include a blank row, DMIN and DMAX will check ALL rows in entire database!
3. Use Column Index Number: Instead of typing text "Sales", you can use column index number 3 as field argument (example: =DMIN(A1:C6, 3, E1:F2)).
4. Use Comparison Operators: You can use operators like >, <, >=, <=, <> inside criteria cells (example: ">500" or "<1000").

📚 Related Resources & Tutorials

• How to Use DSUM Function in Excel
• How to Use MIN and MAX Function in Excel
• How to Use SUBTOTAL Function in Excel
• How to Use FILTER Function in Excel
• Top 15 Basic Excel Formulas for Beginners ↗