Please enable JavaScript to view the comments powered by Disqus.


Using COUNTIF with more then one criteria

When you want to measure count for multiple condition you use COUNTIFS. 

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