top of page


The COUNTIF function assists in counting the number of cells within a designated range that satisfy a particular condition.

The syntax of this formula is: =COUNTIF(range,criteria)

The COUNTIF function uses two arguments:

  1. range – what is the range of cells in which we’d like to count cells which meet certain criteria?

  2. criteria – what is the criteria we’d like to check?

bottom of page