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.