DAVERAGE

Returns the average of a specified column in given data range.

Syntax

=DAVERAGE(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 calculate average for.

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 average of the matching column.

Example

Function

Result

Comment

=DAVERAGE(A5:C9,2,A2:C3)

DSUM

21.5

Evaluates the average age in “Berlin”.