CountIf Formula in Excel

It will help you to count the number of cells that matches your specified condition in your Excel sheet.

Previously In Excel FormulasHow to use Count Formula in Excel?

COUNTIF Formula breakdown:

=COUNTIF(range, criteria)

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:

  1. The number of cells greater than 100
  2. The number of cells that have a Red value
  3. The number of cells that start with the letter R
CountIf Formula in Excel

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.:

=COUNTIF(

CountIf Formula in Excel

STEP2: Working WIth COUNTIF Arguments (First Condition)

Range

In the place of range, you need to mention the range of values that you want to check against your condition like this:

=COUNTIF(A2:A6

CountIf Formula in Excel

criteria

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.

=COUNTIF(A2:A6, “>100”)

CountIf Formula in Excel
Here I got my count of numbers that are greater than 100.

STEP2: Working WIth COUNTIF Arguments (Second Condition)

Now do the same for second condition; counting the number of Red values:

=COUNTIF(C2:C6, “Red”)

CountIf Formula in Excel
Here is the count of values that have the Red text.

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.

=COUNTIF(E2:E6, “R*”)

CountIf Formula in Excel
At last, I got my count of values that have a starting letter of R.