Example
Generic Formula
What It Does
This formula will take the average of a numerical range then return the count of the items in the range that are less than the average.
How It Works
AVERAGE(Numbers) will return the arithmetic mean or average of the Numbers. In our example this is (13+5+7+9+20+3+4+6)/8 = 8.4. “<"&8.4 then creates the text string “<8.4" which is used as a condition in our COUNTIF function. COUNTIF(Numbers,”<8.4") will then count all the numbers in our list which are less than 8.4. In our example this results in 5 since there are 5 numbers in the list that are less than 8.4.