Wauvel

Excel like a finance pro.

← The library

Database function

DAVERAGE

Averages values in a table column that match criteria.

Rarely usedDifficulty 1350 · AdvancedUsage rank #319 of 520
Practice · 2 questions →

When to use it

Averages a column for rows matching the criteria range.

The shape of it

Syntax
=DAVERAGE(database, field, criteria)

Worked examples

  • One condition

    =DAVERAGE(A1:E11,"Revenue",H1:H2) → 166.6666667

    West revenues 100, 150, 250.

  • Another column

    =DAVERAGE(A1:E11,"Units",H1:H2) → 3.333333333

    West units 2, 3, 5.

  • AND conditions

    =DAVERAGE(A1:E11,"Revenue",H1:I2) → 200

    West and Units >2: 150 and 250.

Worth knowing

  • AVERAGEIFS is the modern equivalent for AND conditions.
  • Blank cells in the field are ignored.
  • Criteria rows are ORed.

Where it goes wrong

  • #DIV/0! when nothing matches.
  • Header mismatches silently exclude rows.

Related

DSUMDCOUNTDCOUNTADGETDMAXDMIN

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.