Wauvel

Excel like a finance pro.

← The library

Database function

DMAX

Returns the largest value in a table column that matches criteria.

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

When to use it

The largest value in a column for rows matching the criteria range.

The shape of it

Syntax
=DMAX(database, field, criteria)

Worked examples

  • One condition

    =DMAX(A1:E11,"Revenue",H1:H2) → 250

    Largest West sale.

  • OR conditions

    =DMAX(A1:E11,"Revenue",H1:H3) → 400

    West or East.

  • AND conditions

    =DMAX(A1:E11,"Units",H1:I2) → 5

    West and Units >2.

Worth knowing

  • MAXIFS for AND-only conditions.
  • Returns 0 when nothing matches.
  • Dates work; format the result.

Where it goes wrong

  • 0 for no match looks like a real value.
  • Header mismatches return 0.

Related

DSUMDAVERAGEDCOUNTDCOUNTADGETDMIN

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.