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 |