## CountIf Formula in Excel

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

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”) 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”) 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*”) At last, I got my count of values that have a starting letter of R.