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

What is VBA in Excel?

VBA VBA, which stands for Visual Basic for Application, is a programming language developed to work with Microsoft’s Office applications

Read More »

TRUNC Function

The TRUNC function in Excel returns a truncated number based on a specified number of digits. This specified number of

Read More »


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

Read More »
Scroll to Top