COUNT

COUNT returns how many cells in one or more ranges contain numeric values, including dates and times stored as numbers. It skips text, blanks, and error values, making it the standard way to count numeric records.

Excel

=COUNT(B2:B5)

Google Sheets

=COUNT(B2:B5)

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Product	Sales
Widget A	120
Widget B
Widget C	95
Widget D	300

=COUNT(B2:B5)→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

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
Cell row 5 column 1	Cell row 5 column 2

Formula

Runs server-side · free · no signup

How it works

1Specify the range(s) to evaluate: =COUNT(B2:B5).
2COUNT tallies only cells containing numbers (dates count as numbers).
3The result is the integer count of numeric cells.

Need a version for your data?

Try: “Count how many rows in the sales column have a numeric value entered”

COUNTA COUNTBLANK MODE

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

Verified example

Try it with your data

How it works

Related