• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

COUNTIF Function in Excel

April 20, 2021 by Andrew Childress
Countifs Function Excel

Spreadsheets help you quickly filter and analyze data. Let’s learn how to use the COUNTIF function in Microsoft Excel with these easy steps.

Spreadsheets help you quickly filter and analyze data. One quick way to find data matching a specific condition is the COUNTIF function. Let’s learn how to use the COUNTIF function in Microsoft Excel.

How to Use the COUNTIF Function in Excel

Imagine that you have a range of data, and you need to know how many cells contain data matching a certain condition. For example, consider a list of student names and test scores. You might want to know how many students scored 90 or better and made an “A” grade.

Of course, you could count manually, but that gets difficult with large datasets. The COUNTIF function does the work for you.

Begin by clicking into any empty cell in your worksheet. Go ahead and type an = sign. That tells Excel that you’ll be inputting a formula. Continue by typing COUNTIF, then (. So far, your formula reads:

=COUNTIF(

Countif Excel

The COUNTIF formula always asks for two inputs. These are the range and the criteria. The range refers to the data that you want the formula to count from. The easiest way to add it to your formula is to click and drag to select the cells containing test scores. Here, that’s B2:B6. Once you’ve done that, add a comma. The formula is now:

=COUNTIF(B2:B6,

Countif in Excel

The condition is how you tell Excel how to filter the count. Remember, we want 90 or greater here. Ensuring you type the quotation marks, enter:

">=90")

Your finished formula is:

=COUNTIF(B2:B6,">=90")

Countif Function Excel

Hit Enter on your keyboard, and Excel returns your solution: 3. 

Countif formula Excel

COUNTIF works with a variety of conditions. For example, you can search for cells equalling a certain number, or even containing a certain word. This is a great way to save time and quickly process large volumes of data, to find certain cells that contain a given condition. It’s easy to do in Excel.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to find natural log in ExcelNatural Log in Excel
Next Post:Merge and Center in ExcelMerge Cells in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top