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 |