What is the CountIF function on excel?

Countif function is an Excel function that counts the number of cells which answers a criteria.

Countif function looks like this =countif(range,criteria)

Range: the range we want to count.

Criteria: the criteria each cell must meet in order to be counted (if it contains data).