COUNTIF
Counts the number of cells within a range that meet the given criteria
Syntax
COUNTIF(range, criteria)
Parameters
- range: Required. The group of cells you want to count
- criteria: Required. The criteria that defines which cells will be counted
Example
=COUNTIF(A1:A10, ">5")