Of course, you will also have situations like where you want to count the number of cells which match specific conditions because normally everybody gets stuck in these kinds of problem. So, don’t worry here I’m going to tell you a simple way to get rid of this problem. You can solve this with a simple Excel’s formula known as COUNTIFS Formula which is written below.

Previously In Excel Formulas: 3 Ways to Calculate Percentages in Excel

## CountIfs Formula in Excel

The breakdown for COUNTIFS formula:

`=COUNTIFS`(range1, criteria1, [range2], [criteria2], …)

Explanation of formula:

`=COUNTIFS`(range of cells to check1, condition to check against1, [range of cells to check2], [condition to check against2], …)

Now if you are wondering how it works?
So, it will help you to count the number of cells that will be matching to your specified conditions in Excel.

This is almost like that CountIf Formula! It allows you to add even more conditions at a time you needed and that’s important nowadays for everyone and only this made it different then CountIf Formula.

So, without wasting time lets go and try this new formula to count the following from my Excel worksheet to show you as an example:

• Number of times Ronaldo got more than 2,000 sales
• Number of times Messi got more than 2,000 sales

## STEP 1: In first step, I’m targeting on the first situation that is  Ronaldo got more than 2,000 sales?

So, to get this you must enter the COUNTIFS function in a blank cell:

`=COUNTIFS(`

## STEP 2: Now in the second step just continue with the COUNTIFS arguments:

range1, criteria1

Formula to find the names that match “Ronaldo”:

=COUNTIFS(A2:A11:”Ronaldo”

range2, criteria2

Formula to find the sales that are more than 2000

=COUNTIFS(A2:A11:”Ronaldo”,C2:C11,”>2000″)

## STEP 3: After completing the john’s situation now come to the Messi’s situation.

range1, criteria1

Formula to find the names that match “Messi”:

=COUNTIFS(A2:A11, “Messi”,

range2, criteria2

Formula to find the sales that are more than 2,000

=COUNTIFS(A2:A11,”Messi”,C2:C11,”>2000″)