## 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 Formulas****: ****How 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:

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

**=COUNTIF(**

## 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

*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”)**

## STEP2: Working WIth COUNTIF Arguments (Second Condition)

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

**=COUNTIF(C2:C6, “Red”)**

## 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*”) **