Skip to main content
Version: Streamsheets 3.0

DAVERAGE

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

Syntax

=DAVERAGE(DataRange, ColumnIndex, CriteriaRange)

Arguments

NameTypeDescription
DataRangeRangeCell range, that contains the data to evaluate. The range must include the field labels.
ColumnIndexNumberColumn label or index to calculate average for.
CriteriaRangeRangeSpecifies 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

TypeDescription
NumberThe average of the matching column.

Examples

ABC
1NameAgeCity
2Berlin
3
4NameAgeCity
5Miller24Berlin
6Mayer30Oslo
7Smith26Munich
8Jones19Berlin
FormulaResultComment
=DAVERAGE(A4:C8,2,A1:C2)
21.5Evaluates the average age in "Berlin"