Need to know how many numbers are in a range? COUNT tallies cells containing numeric values and ignores everything else. It’s quick, simple, and essential for data analysis.
What Makes COUNT Useful
COUNT gives you instant insights:
- Quick tallies – Count numeric entries in seconds
- Data validation – Verify how many values you have
- Response tracking – See how many people submitted numbers
- Automatic updates – Count changes as data changes
- Foundation skill – Gateway to COUNTA, COUNTIF, and COUNTIFS
The Syntax
=COUNT(value1, [value2], ...)Include cells, ranges, or both. COUNT handles up to 255 arguments.
Example 1: Basic Count
Count how many test scores exist:
| Student | Score |
|---|---|
| Alice | 85 |
| Bob | 92 |
| Carol | |
| David | 78 |
| Emma | 88 |
Formula: =COUNT(B2:B6)
Result: 4
Carol’s blank cell is ignored. Only numeric values are counted.
Example 2: Multiple Ranges
Count numbers across separate columns:
| Product | Q1 Sales | Q2 Sales |
|---|---|---|
| Widget A | 150 | 180 |
| Widget B | 200 | |
| Widget C | 175 |
Formula: =COUNT(B2:B4, C2:C4)
Result: 4
Counts all numeric entries across both quarters. Two blanks are ignored.
Example 3: Mixed Data Types
What gets counted with different data types?
| Entry | Value |
|---|---|
| Number | 42 |
| Text | Hello |
| Date | 1/15/2025 |
| Blank | |
| Formula result | 15 |
Formula: =COUNT(B2:B6)
Result: 3
COUNT includes: 42, the date (stored as a number), and 15. Text and blanks are ignored.
Example 4: Response Tracking
Count how many survey responses included a rating:
| Respondent | Rating |
|---|---|
| Person 1 | 4 |
| Person 2 | 5 |
| Person 3 | N/A |
| Person 4 | 3 |
| Person 5 |
Formula: =COUNT(B2:B6)
Result: 3
Only numeric ratings count. “N/A” and blank cells are excluded.
Example 5: Verification Check
Verify data entry completion for a form:
| Field | Employee 1 | Employee 2 | Employee 3 |
|---|---|---|---|
| Age | 32 | 28 | |
| Years | 5 | 8 | |
| Rating | 4 | 5 | 3 |
Formula for Employee 1: =COUNT(B2:B4)
Result: 3 (all fields complete)
Formula for Employee 2: =COUNT(C2:C4)
Result: 2 (missing years)
Track completion rates across multiple records.
Example 6: Calculating Percentage Complete
Show what percentage of data is filled:
| Month | Sales |
|---|---|
| Jan | $5,000 |
| Feb | $6,200 |
| Mar | |
| Apr | $7,100 |
| May |
Formula: =COUNT(B2:B6)/COUNTA(A2:A6)
(COUNTA counts numbers, text, anything non-blank)
Result: 0.6 or 60%
60% of months have sales data entered. Divides numeric count by total rows.
COUNT vs Similar Functions
| Function | Counts |
|---|---|
| COUNT | Only numbers (including dates) |
| COUNTA | Numbers, text, anything non-blank |
| COUNTBLANK | Empty cells only |
| COUNTIF | Numbers meeting a specific condition |
What COUNT Includes
Counted:
- Whole numbers: 1, 42, 1000
- Decimals: 3.14, 0.5
- Negative numbers: -15, -200
- Dates: 1/1/2025 (stored as numbers)
- Formulas that return numbers: =A2+B2
Not Counted:
- Text: “Hello”, “N/A”
- Empty cells
- Formulas that return text: =IF(A2>10, “Yes”, “No”)
- Logical values: TRUE, FALSE
- Error values: #N/A, #VALUE!
Common Use Cases
Data Entry Progress Track how many fields are completed in forms or surveys.
Response Rates Count how many people provided numeric answers.
Quality Checks Verify expected number of entries exist.
Completion Metrics Calculate percentages of filled vs total cells.
Common Mistakes to Avoid
Expecting Text to Count
- Numbers stored as text (with apostrophe) aren’t counted
- “100” in quotes is text, not a number
- Check cell formatting if numbers don’t count
Confusing COUNT with COUNTA
- COUNT: Only numbers
- COUNTA: Everything non-blank
- Pick the right one for your needs
Including Headers
=COUNT(B1:B10)might include a header=COUNT(B2:B10)starts from data- Headers that are text don’t affect COUNT, but be precise
Start Using It
Open any spreadsheet with numbers. Select a range. Type =COUNT, include your cells, and press Enter. See how many numeric values you have instantly.
COUNT becomes essential once you start tracking data completion.
Questions about COUNT? Want to explore COUNTIF for conditional counting? Let’s connect.