The COUNTIF function counts the number of cells that meet one criterion, such as the cells with a text string, the cells with a certain value, etc. The following formula determines the count of cells greater than the average.
Example: You are working with a dataset with the first name in column A, the last name in column B, and the salary in column C.
Formula 1: To count the number of cells that are greater than the average
= COUNTIF(C2:C12, ">"&AVERAGE(C2:C12))
The average of column C (C2:C12) is $74,927.36, and five values in column C are greater than the average.
Formula 2: To count the number of cells that are less than the average
= COUNTIF(C2:C12, "<"&AVERAGE(C2:C12))
The average of column C (C2:C12) is $74,927.36, and six values in column C are less than the average.
Notes: The COUNTIF function
Formula:
= COUNTIF(Range, "=number")
Explanations:
– The range is required, the range of cells you want to count;
– The number is required, which is the base number.