How to Use COUNT Function in Excel: Simple Guide
Use the
COUNT function in Excel to count how many cells contain numbers in a range. The syntax is COUNT(range), where range is the group of cells you want to count.Syntax
The COUNT function counts the number of cells that contain numbers in a specified range.
- range: The group of cells you want to check for numbers.
excel
COUNT(range)Example
This example counts how many cells in the range A1 to A5 contain numbers.
excel
=COUNT(A1:A5)
Output
3
Common Pitfalls
People often expect COUNT to count all non-empty cells, but it only counts cells with numbers. Text, blanks, or errors are ignored.
To count all non-empty cells, use COUNTA instead.
excel
=COUNT(A1:A5) <em>counts only numbers</em> =COUNTA(A1:A5) <em>counts all non-empty cells</em>
Quick Reference
| Function | What it Counts |
|---|---|
| COUNT(range) | Cells with numbers only |
| COUNTA(range) | All non-empty cells |
| COUNTBLANK(range) | Empty cells only |
Key Takeaways
COUNT counts only cells with numbers in a range.
Use COUNT(range) with the range of cells you want to check.
COUNT ignores text, blanks, and errors.
Use COUNTA to count all non-empty cells, including text.
COUNTBLANK counts only empty cells.