Steps to Follow Using Countif Function:-Step 1: Create a table similar to the picture above. Step 2: In the Cell E2 we will calculate the number of students who have got GPA 4. type this formula in cell E2: =COUNTIF(B2:B9,4) Step 3: Now press ENTER, you will get the value 3 which is a number of students who got GPA 4. Tip 1: In the Criteria portion of the formula, You can use also B3 to get the same result. Because cell B3 contains the value GPA 4. So, in that case formula would be: =COUNTIF(B2:B9,B3) Tip 2: Imagine that you want to find the number students who got GPA more than 3, then the formula would be:
=COUNTIF(B2:B9, “>3”)So, we can also give mathematic condition in criteria. Read More: Learn Text To Column in Excel with Example Tip 3: If you want to find those students whose name contains Roy, then use this formula and see the magic:
We use * before Roy that means find those values who has Roy at the end. By giving * means whatever exists before Roy it will count that.Tip 4: We can also Sum 2 Countif results in another cell. Think you want to sum these 2 Countif result of =COUNTIF(B2:B9,B3) and COUNTIF(B2:B9, “>3”). To do so, you can use this formula given below:
=COUNTIF(B2:B9,B3)+COUNTIF(B2:B9, “>3”)Now You have successfully learned how to use CountIF Function in Excel. Don’t forget to comment your take on the Countif Function.