Please enable JavaScript to view the comments powered by Disqus.


Counting with "AND" condition to account for multiple criteria.

We will COUNTIFS() that is used for counting if we have more then one criteria for a given range.

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