The ‘COUNTIFS’ function is built on the same idea as the ‘COUNTIF’ function.
But, as the name implies, it allows us to set more than one range and criteria. This creates an enormous amount of flexibility.
The actual syntax for the two is shown for comparison below:
‘=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], [criteria_range3, criteria3],…)’
Note: for ‘COUNTIFS’ arguments, beyond the first criteria, range and criteria are optional.
Excel allows up to 127 criteria range/criteria pairs in the ‘COUNTIFS’ function.
This function allows you to drill down into data sets. With this, you can count based on a deeper level of requirements than what a simple ‘COUNTIF’ function will.