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.

Countifs Function