DMAX¶
Returns the largest number in a column of cell range which matches the specified criteria.
Syntax
=DMAX(DataRange, ColumnIndex, CriteriaRange)
Arguments
Name |
Description |
|---|---|
DataRange |
Cell range, that containes the data to evaluate. The range must include the field labels. |
ColumnIndex |
Column label or index to find the maximum value in. |
CriteriaRange |
Specifies the conditions a row in cell range must fulfill. Must define at least one column with a label and a cell below which specifies the condition. |
Return Value
The maximum value of the matching column.
Example
Function |
Result |
Comment |
|---|---|---|
=DMAX(A5:C9,2,A2:C3)
 |
24 |
Evaluates the maximum age in “Berlin”. |