Translations:Documentation/Calc Functions/DAVERAGE/27/en
Formula | Description | Returns |
---|---|---|
=DAVERAGE(A1:E10;D1;A13:E14) | average distance to school where distance to school is greater than 600 | 1010 |
=DAVERAGE(A1:E10;"Weight";A13:E14) | average weight of students for whom distance to school is greater than 600 | 41.8 |