COUNTIF formula counts the number of cells in a range, which meets a given criteria. it works with single criteria only. For multiple criteria COUNTIFS formula can be used.
Syntax of COUNTIF formula:
COUNTIF( range, criteria )
- range : The range of cells that you want to count based on the criteria.
- criteria : The criteria used to determine which cells to count.
The COUNTIF function returns a numeric value.