Wauvel

Excel like a finance pro.

← The library

Database function

DMIN

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

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

When to use it

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

The shape of it

Syntax
=DMIN(database, field, criteria)

Worked examples

  • One condition

    =DMIN(A1:E11,"Revenue",H1:H2) → 100

    Smallest West sale.

  • OR conditions

    =DMIN(A1:E11,"Revenue",H1:H3) → 100

    West or East.

  • AND conditions

    =DMIN(A1:E11,"Units",H1:I2) → 3

    West and Units >2.

Worth knowing

  • MINIFS for AND-only conditions.
  • Returns 0 when nothing matches.
  • Earliest date per criteria with a date column.

Where it goes wrong

  • 0 for no match.
  • Header mismatches return 0.

Related

DSUMDAVERAGEDCOUNTDCOUNTADGETDMAX

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.