DAVG

Syntax:

DAVG(range, condition)

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

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

Example:

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

returns the average of those values in cells B2 to B11 where the corresponding values in cells C2 to 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