COUNTIF Function Explained
The COUNTIF Function in Microsoft Excel counts the number of cells within a range that meet a specified criteria. It takes two arguments: a range of cells and a criteria. The criteria can be a value, an expression, or a cell reference. The function returns the number of cells in the range that meet the criteria.
COUNTIF Function Syntax
COUNTIF(range, criteria)
- range: The range of cells to be evaluated by the criteria.
- criteria: The criteria used to determine which cells to count.