COUNT / COUNTA

COUNT tallies cells holding numbers; COUNTA tallies cells holding anything — text, numbers, or formula results. Use COUNTA to count how many rows actually have data.

Excel

=COUNTA(A2:A100)

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

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1COUNT(A2:A100) counts only numeric cells.
2COUNTA(A2:A100) counts every non-empty cell.
3Use COUNTA to count how many rows are filled in.

Need a version for your data?

Try: “Count how many cells in column A are filled in”

SUMIF SUMIFS COUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

COUNT / COUNTA

Try it with your data

How it works

Related