Excel COUNT Function (Count Numbers) – Examples & Practice
Practice the Excel COUNT function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Count numeric values in column B from B2 to B6.
Formula Syntax
=COUNT(value1, [value2], ...)
- value1: First cell or range to evaluate for numbers.
- [value2]: Optional additional ranges.
- ...: Up to 255 arguments.
What it does
COUNT tallies how many cells in a range contain numbers. It ignores blank cells and ignores text. Use COUNT when you specifically care about numeric density, not general non-blank cells.
Excel COUNT Function Examples
Count numeric cells
=COUNT(B2:B6)
Returns how many cells hold numbers.
Count multiple ranges
=COUNT(B2:B4, B6)
Counts numbers across two areas.
Count with dates
=COUNT(A2:A6)
Counts serial dates stored as numbers.
order-tracker.xlsx
| A | B | |
|---|---|---|
| 1 | Order | Quantity |
| 2 | A100 | 4 |
| 3 | A101 | 0 |
| 4 | A102 | N/A |
| 5 | A103 | 3 |
| 6 | A104 | 6 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use COUNT + COUNTA together to spot text hiding in numeric columns.
- Remember dates count as numbers.
- Switch to COUNTIF when the question is “how many meet a rule?”
COUNT Function Use Cases
- Validate that a column has the expected number of numeric entries
- Size samples before running statistical formulas
- Detect empty numeric fields in surveys or forms
- Pair with data cleaning to find text masquerading as numbers
- Quality checks before importing to another system
Common mistakes - COUNT function not working
- Using COUNT when you need COUNTA for mixed text/number columns
- Expecting COUNT to include blanks as zero
- Including headers that are text in the same range
- Confusing COUNT with SUM
- Using COUNT on entire columns in very large sheets without reason
FAQ
Does COUNT count text?
No. COUNT only counts cells that contain numbers.
Does COUNT count dates?
Yes. Dates are stored as numbers, so they are counted.
What about blank cells?
Blanks are not counted.
How is COUNT different from COUNTA?
COUNTA counts any non-empty cell, including text. COUNT only counts numeric cells.
Does COUNT count TRUE/FALSE?
Logical values inside a normal range reference are not counted as numbers by COUNT.
Comparison
| Function | Counts | Includes text? |
|---|---|---|
| COUNT | Numbers only | No |
| COUNTA | Any non-blank | Yes |
| COUNTBLANK | Blanks only | N/A |
Example
=COUNT(B2:B6) counts numeric cells.
=COUNTA(A2:A6) counts any non-empty cell.
Advanced examples
Conditional counts
For rules like >50, use COUNTIF or COUNTIFS instead of plain COUNT.
=COUNTIF(B2:B6, ">50")
Related functions
COUNTA counts any non-empty cell (including text), while COUNT only counts numbers—pick the one that matches your “row exists” definition.
COUNTBLANK highlights gaps; when you need rules, move to COUNTIF or COUNTIFS.