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.
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:
STEP 2: Now in the second step just continue with the COUNTIFS arguments:
Formula to find the names that match “Ronaldo”:
Formula to find the sales that are more than 2000
STEP 3: After completing the john’s situation now come to the Messi’s situation.
Formula to find the names that match “Messi”:
Formula to find the sales that are more than 2,000