< Go Back

Excel DMAX Function

Firstly, the purpose of Excel DMAX function is used to return the maximum values within a field range, derived from a set of records that match those criteria. In opposite to this, the DMIN function is used in order to get the minimum value.  Moreover, DMAX function is to return the maximum value in a matching record. The returning value is the maximum value in a given field range.

Figure 1: DMAX Function Layout

The syntax of the function

The main syntax for the DMAX function in Excel is:

=DMAX (database, field, criteria)

The main arguments and attributes of the DMAX function are as following:

  • Database– Database range that includes headers
  • Field – Field name to be counted
  • Criteria – Criteria range the includes headers

Use of the Excel DMAX Function

The DMAX function in Excel is as stated above, used in order to find out the maximum value in a given field of sets of records that may match the criteria. The first part database is the range of cells the also include the headers, the next part field is the name of the field from which the mac value is derived from and criteria are the range that matches those in the database.

To get the maximum value from the field of price in the above example, the color has been selected as “blue” and the quantity is >2, it can be shown with these formulas:

= DMAX (B8:E15, “Price” , B5:E6) // field by name

=DMAX  (B8:E15,2, B5:E6) // field by index

Criteria options

There are some wildcards that can be used as available criteria options within this function and a table is there to show what possible available criteria can be used instead:

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar