COUNTIF is a function that helps us count the number of cells within a specific range which meet a certain criteria.



The COUNTIF function uses two arguments:

  • range – what is the range of cells in which we’d like to count cells which meet a certain criteria?
  • criteria – what is the criteria we’d like to check?

Let’s say we want to see how many times the word “cat” appears in the range A1:A10:


We can also use various operators to perform our checks, for example, if we want to count the number of cells in range A1:A10 which contain a number higher than 18, we can type the following:


Notice how we entered the >18 between quotation marks. Also notice that in our criteria we did not mention a specific cell.

Practice COUNTIF