CountIf Formula in Excel
It will help you to count the number of cells that matches your specified condition in your Excel sheet.
COUNTIF Formula breakdown:
The explanation for the formula breakdown:
=COUNTIF(range of cells to check, condition to check against)
If you need to count the number of cells that match a specific condition, then there is a simple way in Excel to count this with the COUNTIF formula!
This formula is very flexible indeed, so I will try to count the following conditions in my Excel worksheet:
- The number of cells greater than 100
- The number of cells that have a Red value
- The number of cells that start with the letter R
Here are steps mentioned below with explanation to apply this formula:
STEP1: Enter COUNTIF Function
Firstly, you need to enter the COUNTIF function in a blank cell of your Excel sheet e.g.:
STEP2: Working WIth COUNTIF Arguments (First Condition)
In the place of range, you need to mention the range of values that you want to check against your condition like this:
In the place of criteria, you need to write the condition that you want to check against.
In my first condition, I will count the number of values greater than 100.
STEP2: Working WIth COUNTIF Arguments (Second Condition)
Now do the same for second condition; counting the number of Red values:
STEP4: Working WIth COUNTIF Arguments (Third Condition)
Now I will go for the third condition; counting the number of names starting with the Letter R:
I will use the wildcard expression R*
NOTE: * will signifies the wildcard character i.e. Return any value that begins with an R.