COUNT Function in Excel: Count Cells That Contain Numbers

📎 This article includes 1 downloadable practice file ↓

Excel Core FunctionsLevel: Foundational → IntermediateCompatibility: All Excel Versions

In this article

1. Syntax & Parameter Breakdown
2. Where You Will Use It
3. Practical Worked Examples
4. Mistakes People Make & How to Avoid Them
5. Frequently Asked Questions
6. Does COUNT count dates and times?
7. How do you count cells that contain numbers stored as text?
8. What is the difference between COUNT and COUNTA?
9. COUNT in practice
10. Where you will use it
11. Worked example
12. Mistakes people make
13. Continue learning

The COUNT function in Excel is an essential spreadsheet tool designed to Count the number of cells in a range or argument list that contain numbers, including positive/negative values, decimals, and dates.

Syntax & Parameter Breakdown

=COUNT(value1, [value2], ...)

Argument	Requirement & Description
value1	Required. The first item, cell reference, or range within which you want to count numbers.
value2, ...	Optional. Up to 255 additional items, cell ranges, or values to count.

Where You Will Use It

Used to determine sample sizes, count completed numeric survey responses, verify transaction records, and calculate valid data points in statistical models.

Practical Worked Examples

Here are common real-world formula scenarios utilizing COUNT:

Formula	Expected Behavior & Purpose
=COUNT(A2:A100)	Counts how many rows in A2:A100 contain valid numeric data or dates.
=COUNT(B2:D50)	Counts numbers across a multi-column rectangular grid.
=COUNT(A2:A100, C2:C100)	Counts numeric cells across non-contiguous ranges.

Mistakes People Make & How to Avoid Them

COUNT strictly ignores text, blank cells, logical TRUE/FALSE values, and errors. Numbers stored as text (e.g. from CSV imports with leading apostrophes) are not counted.

Frequently Asked Questions

Does COUNT count dates and times?

Yes! Excel stores dates and times as serial numbers, so COUNT recognizes and counts them accurately.

How do you count cells that contain numbers stored as text?

Use =COUNT(INDEX(–A2:A100,)) or convert the column to numbers using Data > Text to Columns.

What is the difference between COUNT and COUNTA?

COUNT tallies only numeric cells, while COUNTA counts any cell that is not empty (including text and errors).

📚 Master spreadsheet formulas with our Free Excel Course or explore related functions in the Formula Lab.

COUNT in practice

Where you will use it

• How many numeric marks were entered
• How many invoices have an amount
• Check a column has no text-numbers

Worked example

Running count of numeric cells only.

Entry	Formula	Result
120	=COUNT($A$2:A2)	1
Absent	=COUNT($A$2:A3)	1
(blank)	=COUNT($A$2:A4)	1
95	=COUNT($A$2:A5)	2

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Using COUNT to count names	COUNT counts numbers only; use COUNTA
Numbers stored as text are skipped	Compare COUNT with COUNTA to find them

Continue learning

All Statistical guides →

GAMMAINV Function in Excel: Inverse Gamma (Older Name)GAMMAINV returns the value at a gamma probability. It is a compatibility function: Excel…GAMMADIST Function in Excel: Gamma Distribution (Older Name)GAMMADIST returns the gamma probability. It is a compatibility function: Excel keeps it so…TTEST Function in Excel: t-Test (Older Name)TTEST returns the p-value of a t-test between two samples. It is a compatibility…GAMMA.INV Function in Excel: Value for a Gamma ProbabilityStatisticsLevel: ExpertAvailable in: Excel 2010+GAMMA.INV returns the value at a given gamma probability.Syntax=GAMMA.INV(probability, alpha.

📎 Practice files for this article

• 📗
  Practice workbook: Statistics basics22 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 34 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.