DMAX
Returns the maximum value from selected database entries.
DatabaseDatabase & Lists
What it does
Finds the largest number in a database column that matches criteria.
Syntax
DMAX(database, field, criteria)
Arguments
database(range) — The range of cells.field(text) — The column to check.criteria(range) — The conditions range.
Examples
Max Sales
Find max sales for 'East'.
FORMULA
=DMAX(A1:B5, "Sales", D1:D2)
RESULT
500
SAMPLE DATA
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Region | Sales | Region | |
| 2 | East | 200 | ||
| 3 | West | 300 | ||
| 4 | East | 500 | ||
| 5 | North | 100 | ||
| 6 | East |