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

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 WORKBOOK

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

=COUNTIF(

CountIf Formula in Excel

 

STEP 2: The COUNTIF arguments:

Table of Contents

range

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

See also  Named Ranges with Vlookup Formula

=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 itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

See also  UNIQUE Formula in Excel
CountIf Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

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!