How to Use DAVERAGE Function in Excel + Tips (Video in Khmer)

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

What is DAVERAGE Function in Excel?

The DAVERAGE function is a Database formula in Microsoft Excel that help you calculate the average number in a column of a table or database that match specific criteria you set in a criteria range.

Unlike standard AVERAGE function, DAVERAGE use a separate criteria table header range, which make complex filtering and condition setup very easy to set up!

📚 Related Tutorial: Prefer standard conditional average formulas? Check out AVERAGEIF vs AVERAGEIFS in Excel: Easy Guide!

🛠️ Formula Syntax

=DAVERAGE(database, field, criteria)

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

📋 Sample Data Table (Follow Along)

To test DAVERAGE easily, create this main database table in cell 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: Average Sales for North Region

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

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

Calculation: ($500 + $800 + $400) / 3 👉 Result: $566.67

Example 2: DAVERAGE with AND Condition (North Region AND Sales > 500)

Set Criteria Range E1:F2:

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

Formula:

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

👉 Result: $800 (Matches Lina only: $800 / 1).

Example 3: DAVERAGE with OR Condition (North Region OR South Region)

Set Criteria Range E1:E3 (Using 2 rows):

• Cell E2 = "North"
• Cell E3 = "South"

Formula:

=DAVERAGE(A1:C6, "Sales", E1:E3)

Calculation: ($500 + $700 + $800 + $600 + $400) / 5 👉 Result: $600 (Average of all sales).

⚡ DAVERAGE vs AVERAGEIFS Comparison

📹 Video How to Use DAVERAGE Function in Excel in Khmer

📹 Video How to Use AVERAGE Function in Excel in Khmer

💡 Quick Tips for DAVERAGE Function

1. Headers Must Match Exactly: Column headers in your criteria box (like "Region") must match your main database headers exactly!
2. Avoid Empty Criteria Rows: If your criteria range includes an empty blank row, DAVERAGE will calculate average of ALL rows in your database!
3. Non-Numeric Cells Ignored: DAVERAGE automatically ignores text and blank cells when calculating average value.
4. Use Column Index Number: Instead of typing text "Sales", you can use column index number 3 (example: =DAVERAGE(A1:C6, 3, E1:F2)).

📚 Useful Resources

• SUMIF vs SUMIFS Function in Excel
• AVERAGEIF vs AVERAGEIFS Function in Excel
• How to Use DSUM Function in Excel
• How to Use DMIN and DMAX Function in Excel
• Top 15 Basic Excel Formulas for Beginners ↗