Please enable JavaScript to view the comments powered by Disqus.


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

How to count if greater then a critieria

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. 


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