# Excel Formulas - Count cells using less than operator

## Count cells using less than operator

**Syntax of used function(s)**

COUNTIF(criteria_range, criteria)

**Explanation**

To count the number of cells from a cell range for a specific criteria using less than operator the COUNTIF function can be used.

**Formula**

```
=COUNTIF(C5:C10,"<70")
```

**How this formula works**

In the above example COUNTIF search the grade point of the employees from the range C4:C10 who achieved grade point below 70 and counts and return the result.

## Count cells with less than using range name and criteria range

**Explanation**

To count the number of cells from a range name for a specific criteria using less than or equal operator the COUNTIF function can be used.

**Formula**

```
=COUNTIF(Grade_Point,E8)
```

**How this formula works**

In the above example the COUNTIF function search the grade point from the range name "Grade_Point" against a particular criteria. The criteria is a variable and written in the cell E8. The COUNTIF function then count the number of grade point matching in the range name and returns the result.

## Count cells using less than operator and concatenate operator

**Explanation**

To count the number of cells from a range name for a specific criteria value and an operator, the COUNTIF function can be used.

**Formula**

```
=COUNTIF(Grade_Point, "<=" & E8)
```

**How the formula works**

In the above example the COUNTIF function search the grade point from the range name "Grade_Point" against a particular criteria using less than or equal operator. The criteria is a variable and contain in cell E8. The less equal to operator and the criteria variable have been concatinate with the operator &.

**Previous: ** Excel Formulas - Count cells between numbers

**Next:**
Excel Formulas - Count number of cells which are blank

**Weekly Trends and Language Statistics**- Weekly Trends and Language Statistics