Please enable JavaScript to view the comments powered by Disqus.


COUNTIFS(...(...C4:C13),(...">"&"30"),(...B4:B13),(..."Girls"))

How to do nested criteria count with COUNTIFS

We can use COUNTIFS when trying to nest the conditions with counts, as it takes multiple criteria and multiple lookup ranges we can get the desired count. 


Used Functions

Category: Statistical

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

Syntax

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

Lets chat on this