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.
Using COUNTIFS() with multiple criteria
How to countif with and condition
Performing Countif with two conditions
Counts the number of cells within a range that meet multiple criteria
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]â€¦)
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM