Please enable JavaScript to view the comments powered by Disqus.


Using countif with multiple criteria.

We actually use COUNTIFS() when it comes to multiple criteria count problems. The COUNTIFS function take multiple lookup ranges as well as multiple criteria to give the result. 

Used Functions

Category: Statistical

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


COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Lets chat on this