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 following formula is to help you get the count of cells that are less than or equal to a particular value.

**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 how many persons' salaries are less than or equal to $70,256

= COUNTIF(C2:C8, "<=70256")

The salaries are in column C. The result returns 3 and there are three people with a salary that is less than or equal to $70,256.

**Formula 2:** To count how many persons' salaries are less than or equal to $75,000

= COUNTIF(C2:C8, "<=75000")

The salaries are in column C. The result returns 5 and there are five people with a salary that is less than $75,000.

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

**Practice: **Count Cells less than or equal to