» Counting the Number of Values Below or Above Average

Problem:

Counting the number of values in List1 (column A) that are below the range's average, as well as the number of values above average.

Solution:

Use the COUNTIF and AVERAGE functions as shown in the following formulas:
To count values below average:
=COUNTIF(A2:A9,"<"&AVERAGE(A2:A9))
To count values above average:
=COUNTIF(A2:A9,">"&AVERAGE(A2:A9))