Excel Formulas - Count cells using greater than operator

Count cells using greater 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 greater than operator the COUNTIF function can be used.

Formula

=COUNTIF(C4: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 more than 70 and counts and return the result.

Count cells with greater than using range name and criteria range

Explanation

To count the number of cells from a range name for a specific criteria using greater 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 greater 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 this formula works

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

Previous: Excel Formulas - Count multiple criterias using logical NOT
Next: Excel Formulas - Count cells which are not equal to each value of a given range