DMAX

DMAX finds the largest numeric value in a database column among all rows that satisfy the criteria range, equivalent to a conditional MAX with complex multi-column filtering. It is ideal for finding the best result in a filtered dataset without helper columns.

Excel

=DMAX(A1:C5,"Revenue",E1:E2)

Google Sheets

=DMAX(A1:C5,"Revenue",E1:E2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2	Cell row 1 column 3	Cell row 1 column 4	Cell row 1 column 5
Cell row 2 column 1	Cell row 2 column 2	Cell row 2 column 3	Cell row 2 column 4	Cell row 2 column 5
Cell row 3 column 1	Cell row 3 column 2	Cell row 3 column 3	Cell row 3 column 4	Cell row 3 column 5
Cell row 4 column 1	Cell row 4 column 2	Cell row 4 column 3	Cell row 4 column 4	Cell row 4 column 5
Cell row 5 column 1	Cell row 5 column 2	Cell row 5 column 3	Cell row 5 column 4	Cell row 5 column 5

Formula

Runs server-side · free · no signup

How it works

1Create your database with headers and a criteria range with the conditions you want to filter by.
2Enter =DMAX(database, field, criteria) — the field is the numeric column to evaluate.
3Change the criteria to instantly see the maximum for a different group or segment.

Need a version for your data?

Try: “What is the highest revenue among East region orders?”

DSUM DAVERAGE DCOUNT

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

DMAX

Try it with your data

How it works

Related