DAVG

Calculates the arithmetic mean of the values in a data set created from a condition.

Syntax:

DAVG( range, condition )

Returns the arithmetic mean (average) of all the values in the range for which the corresponding condition is satisfied.

The condition will normally compare a range against a value or another corresponding range.

Formula:

DAVG, x = ( i 1n xi )  ∕  n

where n is the number of selected values and xi is the i‑th value from the selection.

Example:

DAVG(B2:B11, C2:C11>=50)

returns the average of those values in cells B2:B11 where the corresponding values in cells C2:C11 are greater than or equal to 50.

Example conditions:

C2:C11<D23 compares each element of the range C2:C11 against the value in cell D23
C1:C100="^#Acorn^#"  will return TRUE for any cell in the range C1:C100 which contains the word Acorn.
D1:D10>E1:E10 compares each cell in the range D1:D10 with the corresponding cell in the range E1:E10