Menu
EXCEL DMAX FUNCTION
Excel DMAX Function Introduction
The Excel Dmax function returns the maximum value in a field (column) in a database for just chosen records. A collection of one or more user-specified criteria defines the records that will be included in the computation.
Description of Excel DMAX Function
Syntax :
=DMAX ( database, field, criteria )
Parameters :
- The following are the arguments:
Database :
- A range of cells containing the database. The field names should be specified in the database’s first row.
Field :
- The database field (column) that you want the most of. This can be a field number or the field name (i.e. the header on the top row of the database) enclosed in quotes (e.g. “Area”, “Quarter”, etc).
Criterion :
- A range of fields containing the criteria for determining which records should be included in the computation. The range can include one or more criteria, which are displayed in one cell as a field name and the condition for that field in the cell below.
Eg :
| Quarter | Area |
| >1 | North |
Step By Step Guide of DMAX Function
Example :
If we wanted to discover the greatest sales number in the North area during quarter 2 in the sample database, we might use the Dmax function, as shown below. The requirements are stated in cells F1 – G2 in the example, and the Dmax formula is shown in cell F3: The above Dmax function computes the maximum of the values in cells D6 and D7, yielding the result $340,000. It’s worth noting that, in the preceding function, instead of putting “Sales,” we might have just used the number 4.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
