The countifs Function is used when you want to count data with multiple criteria.
=COUNTIFS (range1, criteria1, [range2], [criteria2], ...)
*It is vital to add the parenthesis surrounding your criteria. Pay attention to the placement.
- range1 – First range to count based on criteria 1.
- criteria1 – The criteria to use on range1.
- range2 – The second range to count based on criteria 2. [optional]
- criteria2 – The criteria to use on range2. [optional]
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.