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)

DSUM

24

Evaluates the maximum age in “Berlin”.