COUNTIF

In this case, we have a table with the names and the score of each one of them, also a criteria table.
We want to know, how many students were approved with 8,9 and 10 score.
In order to solve this problem, we open the dialog box of our tool.

Finally we press the Ok button. The result is showed below:

We can realize that they are 5 people with score 8, there are 9 people with score 9 and 1 person with score 10.
In this case we have counted those values equal to the small criteria table. Simple!!

This tool, besides, allow us to make opertaions, such as Greater, Less, Equal or greater than, Equal or less than, searching of text, etc.

Now, imagine all of the time and work that you would save if this table was 10 or 20 larger.