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

Leave a Reply


The Excel ISOWEEKNUM function takes a specified date and returns a week number (1-54). The returned week follows the ISO

Read More »

ROUND Function

The ROUND function in Excel returns a number rounded to a given number of digits. This can be used to

Read More »
Scroll to Top