Please enable JavaScript to view the comments powered by Disqus.


Performing Countif with two conditions

We can do two or multiple countif by using COUNTIFS() function. Here we put multiple lookup ranges and multiple criteria to count. 

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