DMAX () function (returns conditional maximum value) in Excel
As you know, the MAX () function helps you return the largest of the input values. But if you want to get the maximum value that satisfies a given condition, the MAX () function cannot do it. To do that you need to use the DMAX () function, the DMAX () function will help you get the maximum value and satisfy the input conditions.
If you do not know the syntax and usage of the DMAX () function, you follow the article below:
Description
DMAX () is the function that returns the maximum value in a column in a list or database that satisfies the condition that you give.
Syntax
= DMAX (database, field, criteria)
Inside:
- database: list or related database including column headers.
- field: the field (column) needs to get the maximum value. You can enter the column header directly in quotation marks or some representing the column position in the database: 1 for the first column, 2 for the second column, etc., you can also enter the cell containing the required column header. Using example B3, C1 .
- criteria: is the range of cells that contain conditions, you can choose any as long as the range contains at least one column header and the cell below the column header contains conditions for the column.
Note
- You should set the criteria range on the worksheet so that when adding data, the range of conditions does not change.
- The scope of the conditions that need to be separated is not inserted into the list or database to be processed.
- Criteria must contain at least column headers and a cell containing conditions under column headers.
For example
Find the highest salary of female employees in the following data table:
Firstly, facilitating Gender as a Female.
Next apply the DMAX formula:
= DMAX (B8: F14, F8, D5: D6)
B8: F14 is the data table to find the highest salary.
F8 is the Salary column, the column to find the highest salary value.
D5: D6 is the criteria condition area.
Your results will be as follows:
The article has described, presented the syntax and with specific examples hope you will understand and know how to use the DMAX () function in Excel. Good luck!
You should read it
- How to use MAXIFS function in Excel 2016
- How to use DSUM function in Excel
- How to use COUNTIF function on Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- How to use the IF function in Excel
- Usage of Min and Max functions in Excel
- F.TEST function - The function returns the result of the F - test in Excel
- CHOOSE function combines SUM - Conditional sum in Excel
May be interested
- DMIN () function (returns the minimum value by condition) in Exceldmin () function helps you find and return the smallest value in a column in a list or database that meets the conditions that you give.
- AVERAGEIF function (returns the average value according to the condition) in Excelthe averageif () function returns the average value of all selected cells that meet the conditions you specify.
- COUNTBLANK function - Count the number of blank (empty) cells in a selected range or array in Excelthe countblank () function helps to count the number of blank (empty) cells in a selected range or array in excel.
- DPRODUCT function in Excelthe dproduct () function returns the value of the multiplication of values in a column of a list or database under a specified condition.
- Syntax and description of search and reference functions in Excelthe following article summarizes the syntax and description of the search and reference functions in excel.
- The syntax and function of each function in the group of statistical functions in Excelthe statistical function is divided into 3 subgroups: the statistical group, the probability distribution function group and the linear regression and correlation function group.