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
database: The table, with its column labels in the first row.field: The column to work on: its label in quotes ("Profit") or its number counting from 1.criteria: The conditions: a range with column labels in its first row and what to match below them.
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
Ana's largest sale
A B C D E 1 Rep 2 Ana 1200 3 4 Region Rep Sales 5 North Ana 1200 6 South Ben 800 7 North Chloe 900 8 West Ana 400 9 North Ana 300 In E2:
=DMAX(A4:C9, "Sales", A1:A2)→ 1200
Common mistakes
- No match. With no matching row, DMAX gives 0.
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.
- Czech: DMAX
- Danish: DMAKS
- Dutch: DBMAX
- Finnish: TMAKS
- French: BDMAX
- German: DBMAX
- Hungarian: AB.MAX
- Italian: DB.MAX
- Norwegian: DMAKS
- Polish: BD.MAX
- Portuguese (Brazil): BDMÁX
- Portuguese (Portugal): BDMÁX
- Russian: ДМАКС
- Spanish: BDMAX
- Swedish: DMAX
- Turkish: VSEÇMAK