Please enable JavaScript to view the comments powered by Disqus.


COUNTIF(...B4:B13,(..."="&"20"))

Count numbers in your data

For a given criteria or condition the COUNTIF() function performs a match in the provided range of cells, and return the values that matches the criteria, for this case it is 20.  


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