Status tracking
Count open tickets, active users, paid invoices, or overdue items in a tracker.
Spreadsheet utility
COUNTIF and COUNTIFS Formula Generator
COUNTIF and COUNTIFS power a lot of trackers, KPIs, and status summaries. This page helps you count matching rows cleanly without turning a simple metric into a brittle formula.
Use this page when the answer should be how many rows match, not how much value to add. Build COUNTIF and COUNTIFS formulas from plain English.
One or many criteriaTracker and KPI friendlyClear counting logic
Overview
Use COUNTIF and COUNTIFS when the question is how many, not how much
COUNTIF and COUNTIFS are straightforward once you understand the structure, but they still create friction when a KPI or tracker needs to be built quickly and the criteria have to line up exactly.
This page is designed for counting logic specifically. If the business question is how many records match the rule, this is the right landing page.
How to use it
How to turn a counting rule into a clean formula
Step 1
Describe what should be counted and what conditions define a match.
Step 2
Choose Excel or Google Sheets.
Step 3
Copy the formula and confirm that each criteria range covers the same rows.
Use cases
Tracker and KPI jobs this page is built for
Category summaries
Count rows by region, department, role, source, or workflow stage.
Dashboard KPIs
Build simple count-based metrics for weekly reporting and operational snapshots.
Practical examples
Count-based formulas you can copy and adapt
These examples focus on common dashboard and tracker questions where the output should be a count of matching rows.
Region count
Prompt: Count rows where region is East
Example formula
=COUNTIF(B:B,"East")Counts how many rows in column B match the region East.
Open orders
Prompt: Count orders where status is Open
Example formula
=COUNTIF(C:C,"Open")Counts the rows in column C that contain the status Open.
March invoices
Prompt: Count invoices where month is March
Example formula
=COUNTIF(B:B,"March")Counts how many rows are tagged March in the month column.
Active admins
Prompt: Count users where role is Admin and status is Active
Example formula
=COUNTIFS(B:B,"Admin",C:C,"Active")Counts only the rows where both the role and status criteria are true.
The difference
COUNTIF is for one condition and COUNTIFS is for several
If you only need one condition such as East, Open, or Active, COUNTIF keeps the formula short. If you need multiple rules applied together, COUNTIFS is the better fit.
This page keeps the distinction clear and uses example prompts that mirror the kinds of operational counts people actually build.
Why it matters
Counting correctly is the backbone of many lightweight dashboards
A surprising number of recurring team dashboards are built on formulas like COUNTIFS. When the syntax is off or the criteria range is misaligned, the KPI itself becomes unreliable.
This page also keeps the distinction clear between counting and totaling, because COUNTIFS and SUMIFS often get confused when the spreadsheet question is phrased loosely.
FAQ
Frequently asked questions
What is the difference between COUNTIF and COUNTIFS?
COUNTIF counts rows using one condition. COUNTIFS handles two or more conditions together.
How is this different from SUMIF and SUMIFS?
COUNTIF and COUNTIFS count matching rows. SUMIF and SUMIFS add numeric values for rows that match the criteria.
Can I count text values?
Yes. Counting categories, statuses, labels, and regions is one of the most common uses for these functions.
Can I count by date?
Yes. Date-based counts are common for deadlines, months, periods, and reporting windows.
Does it work for dashboards?
Yes. COUNTIF and COUNTIFS are often used in KPI summaries, trackers, and lightweight dashboards.
Is it useful for Google Sheets too?
Yes. Both functions are useful in Google Sheets as well as Excel.
Next pages
Need totals instead of counts?
If the answer you need is a summed amount rather than a number of matching rows, the SUMIF and SUMIFS page is the better next step.
SUMIF and SUMIFS Formula Generator
Total amounts by one or many conditions for reports, dashboards, and trackers.
IF Formula Generator
Turn thresholds, blank checks, and status rules into IF and nested IF formulas.
Excel Formula Generator
Start from a plain-English task and get a full Excel formula you can adapt.
Formula Examples
Browse copy-ready reference formulas before generating something more custom.