The COUNT function is one of Excel’s simplest and most useful tools for working with numbers. It allows you to quickly count how many cells in a range contain numeric values, saving time and reducing manual counting errors.
In this guide, you’ll learn:
- What the COUNT function does
- How to use COUNT step-by-step
- What types of data COUNT includes
- What COUNT does not count
- How to use COUNT with multiple ranges
- Common mistakes and how to fix them
What the COUNT Function Does in Excel
The COUNT function counts the number of cells in a range that contain numeric values.
This includes:
- Numbers
- Dates
- Times
- Percentages
- Currency values
It does not count:
- Text
- Blank cells
- Logical values (TRUE/FALSE)
- Errors
COUNT Function Syntax
Here is the formula structure for the COUNT function:
=COUNT(value1, [value2], ...)
Arguments:
- value1 — The first number or range to count
- value2 — (Optional) Additional numbers or ranges
Most of the time, you’ll use COUNT with a range of cells, like this:
=COUNT(A2:A11)
This counts how many cells in A2 through A11 contain numeric values.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> COUNT Function Data
Your First COUNT Formula (Step-by-Step)
Let’s walk through a simple example.
Imagine you have a list of daily sales totals, but some days have missing entries.
You want to count how many days actually have recorded numeric sales.
Click in cell B10.
Type:
=COUNT(B2:B8)
Press Enter.
The result should is 5. That means: out of 7 cells in the Sales column, 5 contain numeric values. The blank cells were ignored.
What COUNT Actually Counts
COUNT includes any value stored as a number. This includes more than just whole numbers.
COUNT will count:
- 150
- 99.5
- $1,200
- 45%
- Dates (like 1/1/2025)
- Times (like 8:30 AM)
These are all stored as numeric values in Excel.
What COUNT Does NOT Count
COUNT ignores any cells that do not contain numeric values.
COUNT will NOT count:
- Text
- Blank cells
- Words
- Logical values
- Errors
It only counts 150 and $50.
Using COUNT with Multiple Ranges
COUNT can count numbers from multiple ranges at once.
Example:
=COUNT(B2:B8, C2:C8)
This counts numeric values in both ranges.
Common COUNT Mistakes (and Fixes)
Even though COUNT is simple, a few common mistakes can cause confusion.
Mistake 1 — Expecting COUNT to Count Text
Problem:
You use COUNT but expect text entries to be included.
Example:
=COUNT(A2:A10)
If cells contain words, COUNT ignores them.
Fix:
Use:
=COUNTA(A2:A10)
Mistake 2 — Numbers Stored as Text
Sometimes numbers look like numbers but are stored as text.
COUNT will ignore them.
Signs this happened:
- Numbers align left
- COUNT result is lower than expected
Fix:
Convert text numbers to real numbers using:
- Convert to Number
- Or multiply by 1
When You Should Use COUNT
Use COUNT when you need to:
- Count recorded sales totals
- Count numeric test scores
- Count completed measurements
- Count dates entered
- Count how many numeric records exist
COUNT is especially useful when checking:
- Whether data exists
- How many values are recorded
- Whether entries are missing
COUNT Function Tips
Keep these useful tips in mind:
- COUNT ignores blanks automatically
- Dates count as numbers
- Text numbers are ignored
- COUNT works with multiple ranges
These small details make a big difference in real-world spreadsheets.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> COUNT Function Data
