Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to count cells that contain numbers in Excel and Google Sheets
Excel & Google Sheets
=COUNT(B2:B6)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Entry | Value |
| A | 10 |
| B | N/A |
| C | 30 |
| D | |
| E | 50 |
=COUNT(B2:B6)→3
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select the range you want to evaluate, e.g. B2:B6.
- 2In an empty cell type =COUNT(B2:B6) and press Enter.
- 3The result is the count of cells in that range that contain numeric values only.
Tips
- COUNT counts numbers and dates (dates are stored as numbers internally) but NOT text representations of numbers like '123 stored as text.
- Use COUNTA to count any non-blank cell (numbers, text, dates, logicals). Use COUNTBLANK for blanks.
- To count numbers meeting a condition use COUNTIF: =COUNTIF(B2:B6,">100") counts cells greater than 100.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Why does COUNT return fewer cells than I expect?
Some cells likely contain numbers stored as text (common after importing data). Use VALUE() to convert them or check with ISNUMBER().
Does COUNT include cells with 0?
Yes — zero is a valid number and COUNT includes it.