Please enable JavaScript to view the comments powered by Disqus.


How to countif with and condition

We use multiple criteria to emulate the AND condition with COUNTIFS to reach the desired result. The COUNTIFS function takes multiple criteria and multiple ranges to get to the final count by using logical operators to build the criteria.

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