Please enable JavaScript to view the comments powered by Disqus.


COUNTIF(...B4:B13,(...">"&"25"))

Using COUNTIF() to count against a criteria

The formula works by adding a logical operator for "greater then" to our criteria. The formula then looks up in the range and give the final count. 


Used Functions

Category: Statistical

Counts the number of cells within a range that meet the given criteria

Syntax

COUNTIF(range, criteria)

Lets chat on this