The COUNTIFS() function allows you to use more than one criteria for the statistic. Often, we think of this as for example, counting the row entries where Country is “Australia” and State is “NSW”
So in this case, there are two rows of Australia, NSW
and the COUNTIF expression is
However, we can also use multiple AND criteria on one parameter e.g. Count how many entries are between 20 and 30
In a related vein, for the visual Conditional Formatting, we can create more than one Rule on a Worksheet. Often, we may use a different Rules for different parts of the Worksheet. But, there’s nothing stopping you from using more than one Rule (as long as the Rules don’t overlap in scope) on the same cell block.
In case you want to look around:
Here’s a Microsoft produced video tutorial on SUMIF and COUNTIF functions:
and a downloadable Powerpoint Presentation on nested IFs