FormulaGym
XP 0
Streak 0

The COUNT function in Excel

COUNT tells you how many cells in a range contain numbers.

What COUNT does

It counts numbers only. Text, blank cells and errors are not counted. That makes it a quick way to spot missing data: compare the count with the number of rows you expect. Dates are stored as numbers, so they are counted too.

Syntax

=COUNT(value1, [value2], ...)
value1
The first cell or range to check.
value2, ...
Optional. More cells or ranges.

Worked example

AB
1ReadingValue
2R112
3R2n/a
4R330
5R425
6R5n/a
7Numbers3
B7 =COUNT(B2:B6)

Five cells hold something, but only three are numbers. The two n/a entries are text, so COUNT skips them.

Now you try

A fresh exercise every time. Press Another exercise as often as you like.

Where you will use it

Data cleanup

Check how many entries in a column are really numeric.

HR

Count how many timesheets have hours filled in.

Sales & Ops

Count how many readings or orders came in.

Common mistakes

  • Using COUNT on a column of names and getting 0. Use COUNTA to count every non-empty cell, whatever it holds.
  • Numbers stored as text are not counted, so the result is lower than you expect.
  • Forgetting that dates count as numbers, which can make a text-and-date column look bigger than it is.

The COUNT course

  1. 1
    Count the numbersFree practice below
    Practise
  2. 2
    Count text entries with COUNTAComing soon
  3. 3
    Count blanksComing soon
  4. 4
    Spot missing dataComing soon
  5. 5
    Count unique entriesComing soon

Common questions

What is the difference between COUNT and COUNTA?

COUNT counts only numbers. COUNTA counts every cell that is not empty, whether it holds a number, text or a date.

Does COUNT include zeros?

Yes. A zero is a number, so it is counted.

Related functions