Excel functions / Database

DMAX function

The largest number in a column of a table among the rows that meet conditions written in cells.

Syntax

=DMAX(database, field, criteria)

Arguments

When to use it

DMAX gives the largest number in one column of a table among the rows that meet conditions in a criteria range.

Examples

  1. Ana's largest sale

    ABCDE
    1Rep
    2Ana1200
    3
    4RegionRepSales
    5NorthAna1200
    6SouthBen800
    7NorthChloe900
    8WestAna400
    9NorthAna300

    In E2: =DMAX(A4:C9, "Sales", A1:A2) → 1200

    Try this example

Common mistakes

DMAX in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try DMAX in the playground

Related functions