Microsoft Excel

COUNTIF Function in Excel

Chris Menard

16 Dec 2018 — 1 min read

One of the most powerful functions in Excel is the COUNTIF function. The COUNTIF function in Excel counts the number of cells that meet criteria you specify. Several examples of when to use COUNTIF:

- How many employees work in the accounting department? - How many customers are in Georgia? - How many orders are over $500?

Syntax

=COUNTIF(Range, Criteria)

The COUNTIF function has two arguments. Both arguments, range & criteria, are required. The criteria can be text, numbers or dates.

Examples of COUNTIF![]

(https://menard-on-microsoft.ghost.io/content/images/2025/09/Countif_functions.jpg)

Excel file - COUNTIF

[Download the Excel file with answers](https://chrismenardtraining.com/_CMT/images/sections/posts/2018/11-2018/COUNTIF_Chris-Menard.xlsx)

The file above is used in the YouTube video.

COUNTIF Function in Excel for numbers, dates, and text by Chris Menard - YouTube

Chris Menard to Present “Executive Insights: Harnessing Excel for Strategic Analysis” at EA Ignite Conference

November 4, 2025 Microsoft MVP and productivity expert Chris Menard will be presenting a highly anticipated session titled “Executive Insights: Harnessing Excel for Strategic Analysis” at the EA Ignite Conference, held at the Renaissance Nashville Hotel. This premier event, running from November 3–5, 2025, is tailored for executive assistants

Chris Menard to Present “Mastering Microsoft 365 Copilot” at EA Ignite Conference

Chris Menard will present “Mastering Microsoft 365 Copilot” at EA Ignite in Nashville on Nov 3, 2025. Learn how Copilot boosts productivity in Word, Excel, PowerPoint, Outlook, and Teams during this hands-on session.

Microsoft Teams: Save Chat and Channel Messages is Back!

How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.