Please enable JavaScript to view the comments powered by Disqus.


Example of COUNTIF() against a criteria

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.

Used Functions

Category: Statistical

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


COUNTIF(range, criteria)

Lets chat on this