Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to count non-blank cells in Excel and Google Sheets
Excel & Google Sheets
=COUNTA(A2:A100)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
- 1Choose a cell for the count.
- 2Enter =COUNTA(A2:A100) to count all non-empty cells in the range.
- 3Use COUNT instead if you only want cells containing numbers.
Tips
- A formula that returns "" looks blank but COUNTA still counts it — use COUNTIF(range, "<>") to exclude those.
- COUNTBLANK does the opposite: it counts the empty cells.
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
What is the difference between COUNT and COUNTA?
COUNT counts only numeric cells; COUNTA counts every non-empty cell, including text and formula results.