The **COUNTIF function** is to count the number of cells that meet one criterion such as the cells with a text string, and the cells with a certain value, etc. The MEDIAN function returns the number in the middle of a set of numbers.

**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 median

= COUNTIF(C2:C12, ">"&MEDIAN(C2:C12))

The median of column C (C2:C12) is $79,058.00, and five values in column C are greater than the median.

**Formula 2: **To count the number of cells that are less than the median

= COUNTIF(C2:C12, "<"&MEDIAN(C2:C12))

The median of column C (C2:C12) is $79,058.00, and five values in column C are less than the median.

**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.