COUNTIF Function

Function COUNTIF

Counts the number of cells within a range that meet the given criteria.

COUNTIF(range,criteria)

Range  is the number of cells to count – in this example, B2 to B9

Criteria  is the criteria we define to count the number of cells – here, we specify the criteria as “>17” i.e,  any cell containing a number greater than 17.

The answer therefore is 5.

Another example of the Countif function using text – the criteria being “B+” where the cells containing B+ are being counted. The answer for this is 3.