Countifs Function in Excel with Multiple Criteria
The countifs Function is used when you want to count data with multiple criteria. See how how to use the countifs function with multiple criteria.
*It is vital to add the parenthesis surrounding your criteria. Pay attention to the placement.
In the below example, we use the countifs function to first look for “Blue” in the A column and only count if the number in column B is greater than 4.