DAVERAGE

DAVERAGE works like AVERAGEIF but uses a structured criteria range, allowing complex multi-column conditions without nested formulas. It is useful for calculating conditional averages in formatted data tables where criteria may change frequently.

Excel

=DAVERAGE(A1:C5,"Revenue",E1:E2)

Google Sheets

=DAVERAGE(A1:C5,"Revenue",E1:E2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2	Cell row 1 column 3	Cell row 1 column 4	Cell row 1 column 5
Cell row 2 column 1	Cell row 2 column 2	Cell row 2 column 3	Cell row 2 column 4	Cell row 2 column 5
Cell row 3 column 1	Cell row 3 column 2	Cell row 3 column 3	Cell row 3 column 4	Cell row 3 column 5
Cell row 4 column 1	Cell row 4 column 2	Cell row 4 column 3	Cell row 4 column 4	Cell row 4 column 5
Cell row 5 column 1	Cell row 5 column 2	Cell row 5 column 3	Cell row 5 column 4	Cell row 5 column 5

Formula

Runs server-side · free · no signup

How it works

1Prepare a database range (with headers) and a separate criteria range (same headers, condition below).
2Enter =DAVERAGE(database, field, criteria) — field can be the header name in quotes.
3Adjust the criteria range to recompute averages for different subsets without touching the formula.

Need a version for your data?

Try: “What is the average revenue for East region orders?”

DSUM DCOUNT DCOUNTA

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

DAVERAGE

Try it with your data

How it works

Related