COUNTIF is an Excel function that counts the number of cells within a range that meet a specified criteria. This function is useful when you need to count how many times a particular value or condition appears in a range of cells.
For example, let's say you have a list of exam scores and you want to count how many students scored above a certain threshold. You can use the COUNTIF function to count the number of cells that meet that criteria:
The syntax for COUNTIF function is as follows:
=COUNTIF(range, criteria)
• range: the range of cells you want to evaluate• criteria: the condition that must be met for a cell to be counted. This can be a number, text, or logical expression.