When using DMAX, the most common questions involve errors, unexpected results, and copying formulas across cells; this FAQ includes 3 common questions and a glossary.
FAQ
What should I do if DMAX returns an error value?
- Check whether the database range, field argument, and criteria range are all filled in correctly.
- Make sure the field header matches the criteria header and that the value column is not affected by text formatting issues.
- If the data contains extra spaces or unusual characters, clean the data and calculate again.
Why does the DMAX result not match what I expected?
- Check whether the criteria range refers to the correct header row and condition values.
- Confirm that the target field is the column from which you want the maximum value returned.
- Review the selected data range again to avoid missing or extra records.
How can I use DMAX in multiple cells?
- Enter the DMAX formula in the first target cell.
- Drag the fill handle or use copy and paste to apply it to additional cells.
- If the formula includes fixed ranges, use absolute references where needed so the references do not shift after copying.
Glossary
| Term | Definition |
|---|---|
| Database | The data range used by DMAX for filtering and calculation, usually with field headers in the first row. |
| Field | The target column that returns the maximum value. It can be a column label or a column index number. |
| Criteria | The criteria range used to filter records before DMAX returns the maximum value. |