Count Numeric Cells

Use COUNT to see how many cells contain numbers — and spot missing data.

You will learn to

• Count only numeric cells with COUNT
• Know when to use COUNTA instead

How it works

COUNT counts cells that contain numbers. COUNTA counts every non-empty cell, including text. Use COUNT to find how many valid numeric entries a column has.

=COUNT(B2:B8)