COUNTIF(...)
How to count if greater then a critieria
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
The formula performs a logical comparison to see if the value is greater then the criteria and then returns and a binary array summed up by COUNTIF.