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:
Syntax
=COUNTIF(range, criteria)
Arguments
• 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.