Database
DMAX Function in Excel
Returns the maximum value from database entries that match specified criteria.
Syntax
- =DMAX(database, field, criteria)
Arguments
- database (required): Range including headers
- field (required): Column to find max (name or number)
- criteria (required): Range with criteria headers and values
Examples
- =DMAX(A1:D10, "Sales", F1:F2) - Maximum sales matching criteria - Result: Max value
D-functions vs DMAX
- Database functions use a criteria range with headers matching your list.
- For simple AND criteria [SUMIFS](/functions/sumifs/) may be easier to audit.
- Compare [SUMIF vs SUMIFS](/compare/sumif-vs-sumifs/) for reporting patterns.
Common errors
- Field must contain numbers
Use cases
- Find highest values
- Database analysis
- Conditional maximum
Frequently asked questions
- What is the difference between DMAX and MAXIFS? MAXIFS uses inline criteria; DMAX uses a separate criteria range. DMAX is better for complex OR conditions and dynamic criteria. MAXIFS is simpler for straightforward AND conditions with fixed criteria.
- How do I find the maximum with OR conditions? Use multiple rows in criteria range. For max sales in 'East OR West' region: put 'Region' header, then 'East' in row 2, 'West' in row 3. DMAX returns the highest value matching either condition.
- Can I use comparison operators in DMAX criteria? Yes, use operators like >100, <=50, <>0 in criteria cells. For sales greater than 1000: put '>1000' in the Sales criteria cell. Combine with other columns for complex filters.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.