DMAX

Formulas / DMAX
Calculate the maximum value in a field from a set of records that match a criteria.
DMAX( database, field, criteria )
  • max - specifies the maximum value to return
  • field - specifies the field to search for the maximum value
  • column - specifies the name of the column to return

Examples

  • =DMAX(A5:E11, "Profit", A1:F3)

    The DMAX function takes three arguments. The first argument is the range of cells that you want to search for maximum values. The second argument is the column label of the range that contains the values you want to return. The third argument is an optional range that contains criteria for the maximum value. In this example, the DMAX function is used to return the maximum profit of any apple tree within 10 feet of row 7 or any pear tree. The pear tree in row 7 meets these conditions and will return a value of $96.

  • =DMAX(A1:A10, "Value", A1:A10, ">5")

    The DMAX function can also be used to return the maximum value of a cell range that has a specified criteria. For example, if you want to find the maximum value in a range of cells that are greater than 5, you can use the DMAX function with the criteria range to return the maximum value. This example will return the maximum value in the range A1:A10 that is greater than 5.

Summary

The DMAX function is used to find the largest number in a field of a list or database. It requires the database, field and criteria arguments to function properly.

  • The DMAX function returns the maximum value in a given field, specified by its name or index, from a set of records that match the criteria given.
  • The arguments for the DMAX function are database, field, and criteria. The database argument is a range of cells that includes the field headers, while the criteria argument is a range of cells with the same headers as in the database.


Frequently Asked Questions

What is the DMAX function?
The DMAX function returns the largest number in a field in a database or list.
What are the arguments for the DMAX function?
The DMAX function requires three arguments:
  • Database: The range of cells making up the list or database
  • Field: The column in the function
  • Criteria: The range of cells with the conditions
How do I use the DMAX function?
The DMAX function should be used with the syntax DMAX(database,field,criteria). The database and field arguments are required, but the criteria argument is optional.
How do I use the criteria argument with the DMAX function?
The criteria argument should be used when you want to limit the results of the DMAX function to specific conditions. For example, if you want to find the largest number in a column that meets certain criteria, you would use the criteria argument to specify the conditions.

Related Functions

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.