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
CountIfs Formula

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(

CountIfs Formula

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”

CountIfs Formula

range2, criteria2

Formula to find the sales that are more than 2000

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

CountIfs Formula
Now you have got your count of 3.

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”,

CountIfs Formula

range2, criteria2

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

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

CountIfs Formula
Now you have got your count of 2