Pinterest Pixel

CountIf Formula in Excel

What does it do? Counts the number of cells that matches your specified condition Formula breakdown: =COUNTIF(range,... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

CountIf Formula in Excel | MyExcelOnline CountIf Formula in Excel | MyExcelOnline

What does it do?

Counts the number of cells that matches your specified condition

Formula breakdown:

=COUNTIF(range, criteria)

What it means:

=COUNTIF(range of cells to check, condition to check against)


Do you have a scenario where you want to count the number of cells that match a specific condition?

I’m sure you do!  There is a simple way to count this with Excel’s COUNTIF formula!

The COUNTIF formula is very flexible indeed, so let us try to count the following from our Excel worksheet:

  • Number of cells greater than 2
  • Number of cells that have a Yellow value
  • Number of cells that start with the letter J

CountIf Formula in Excel

I explain how you can do this below:

CountIf Formula in Excel | MyExcelOnline

Download excel workbookCOUNTIF-FORMULA.xlsx

STEP 1: We need to enter the COUNTIF function in a blank cell:

=COUNTIF(

CountIf Formula in Excel

 

STEP 2: The COUNTIF arguments:

range

What is the range of values that you want to check against your condition?

See also  Simplifying Calculations with Square Root in Excel

=COUNTIF(A9:A12,

CountIf Formula in Excel

criteria

What is the condition that you want to check against?

For our 1st example, we want to count the number of values greater than 2.

=COUNTIF(A9:A12, “>2”)

CountIf Formula in Excel

You now have your count of numbers greater than 2!

CountIf Formula in Excel

 

STEP 3: Now let us try for counting the number of Yellow values:

=COUNTIF(C9:C12, “Yellow”)

CountIf Formula in Excel

You now have your count of values that have the Yellow text!

CountIf Formula in Excel

 

STEP 4: Now let us try for counting the number of names starting with the Letter J:

Let us use the wildcard expression J*

* signifies a wildcard character i.e. Return any value that begins with a J

=COUNTIF(E9:E12, “J*”)

CountIf Formula

You now have your count of values that have a starting letter of J!

CountIf Formula in Excel

 

CountIf Formula in Excel

 

 

If you like this Excel tip, please share it
CountIf Formula in Excel | MyExcelOnline CountIf Formula in Excel | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...