writer
6,694
edits
Changes
Manuals/calci/AVERAGEIF (view source)
Revision as of 19:44, 26 February 2018
, 19:44, 26 February 2018→Description
*The other common measures of central tendency are: Median,& Mode.
*The other common measures of central tendency are: Median,& Mode.
*So this function calculates the average value which satisfies the given condition.
*So this function calculates the average value which satisfies the given condition.
*For example AVERAGEIF([10,20,23.3,67,87,98.3,12.3,45.3,90],""<13"")=11.15
*For example AVERAGEIF([10,20,23.3,67,87,98.3,12.3,45.3,90],"<13") =11.15
==Examples==
==Examples==