Excel COUNT Function

COUNT counts the number of cells in a range that contain numeric values — numbers, dates, and times. It ignores text, blanks, and errors. It is the most basic of Excel's counting functions, and the foundation for understanding COUNTA, COUNTIF, and COUNTIFS.

Syntax

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

Argument	What it means
value1 required	A range, cell, or value to count.
value2, ... optional	Additional ranges or values. Up to 255 arguments.

Basic examples

=COUNT(A2:A100)
-- Returns how many cells in A2:A100 contain numbers

=COUNT(A2:A100, C2:C100)
-- Counts numbers across two separate ranges

COUNT vs COUNTA vs COUNTIF

Function	Counts
COUNT	Cells with numbers only (ignores text and blanks)
COUNTA	Any non-blank cell (numbers, text, errors)
COUNTIF	Cells matching a specific condition
COUNTBLANK	Empty cells only

Practical use: check for missing data

=COUNTA(A2:A100) - COUNT(A2:A100)
-- Returns how many non-blank cells contain text instead of numbers
-- Useful for catching data entry errors in numeric columns

💡 Dates and times count as numbers

Excel stores dates as serial numbers, so COUNT includes them. If a column should contain only dates, COUNT is a reliable check for how many valid date entries exist.

Does COUNT include cells with errors like #N/A?

No. COUNT only counts numeric values. Errors, text, and blanks are all ignored. Use COUNTA to count errors, or COUNTIF with "error criteria" to count specific error types.

What is the difference between COUNT and COUNTA?

COUNT counts only numbers. COUNTA counts everything that isn't blank — text, numbers, errors, logical values. Use COUNT for numeric validation; use COUNTA for "is this cell filled in at all?"

Practice COUNT for real

Type it in a live spreadsheet, get instant feedback. No videos, no downloads.

Start practising free →

Syntax

Basic examples

COUNT vs COUNTA vs COUNTIF

Practical use: check for missing data

Practice COUNT for real