Returns the largest number in a column of a list or database that matches specified conditions.
Sintaxe
DMAX(database, field, criteria)Argumentos
databaseobrigatório
The range of cells that makes up the list or database.
fieldobrigatório
The column label or index number used in the function.
criteriaobrigatório
The range of cells that contains the specified conditions.
The DMAX function searches through a database range to find the maximum value in a specific field. It only considers rows that meet the criteria defined in a separate range of cells.
=DMAX(A1:C10, "Sales", E1:E2)→5000Finds the maximum value in the 'Sales' column for rows matching the criteria in E1:E2.
Set up the database
Ensure your data is organized in a table with headers in the first row.
Define criteria
Create a separate range with the same header as your database and the condition below it.
Enter the formula
Use the DMAX function referencing the database, field, and criteria ranges.
Yes, you can add more rows or columns to your criteria range to filter by multiple conditions.