DMAX
Largest database value matching criteria.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Number
Examples
=DMAX(R1:S4, "amount", U1:U2) | R | S | T | U | |
|---|---|---|---|---|
| 1 | region | amount | region | |
| 2 | north | 100 | north | |
| 3 | south | 200 | ||
| 4 | north | 300 |
Result 300
Syntax
DMAX(database, field, criteria)database- range required
field- any required
criteria- range required
Errors
#VALUE!=DMAX(A1:A3, 2, TRUE)
Related
DAVERAGEAverage of database values matching criteria. DCOUNTCounts numeric database values matching criteria. DCOUNTACounts non-empty database values matching criteria. DGETThe single database value matching criteria. DMINSmallest database value matching criteria. DPRODUCTProduct of database values matching criteria.