How to use the Excel DMAX function

The DMAX Function is categorized under Excel Database functions. The function helps find the maximum value for a specific field/column in a database for selected records based on user-specified criteria.

Syntax: =DMAX(database, field, criteria)

The DMAX function syntax has the following arguments:

  • Database (Required):The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
  • Field (Required): Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as “Age” or “Yield,” or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
  • Criteria (Required): The range of cells that contains the conditions that you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Example: Let’s look at some Excel DMAX function examples and explore how to use the DMAX function as a worksheet function in Microsoft Excel:

Excel DMAX function - How to use the Excel DMAX function

Syntax:  =DMAX(H62:K70,K62,H73:J74)

Result:

Excel DMAX function 1 - How to use the Excel DMAX function

Based on the Excel spreadsheet above, the following DMAX examples would return:

Color: Green
Price: >15
Result: 144

Color: Red
Price: >30
Result: 525

Qty: <15
Price: >20
Result: 504

Color: Green
Qty: <20
Result: 144

Note: The Excel DMAX function gets the maximum value in a given field from a set of records that match criteria. The database argument is a range of cells that includes field headers, field is the name or index of the field to get a max value from, and criteria is a range of cells with headers that match those in database.

Add a Comment

Your email address will not be published. Required fields are marked *