COUNTIF(...)
Example of COUNTIF() against a criteria
Used Functions
Category: Statistical
Counts the number of cells within a range that meet the given criteria
Syntax
COUNTIF(range, criteria)
Practice COUNTIF Formula at Sheetzoom
COUNTIF formula at Microsoft help
0
We can count for a given criteria in a range of cell by using COUNTIF function. This function takes criteria as second argument and provides us count of cells matching that criteria.