Math & Trig
Counting

COUNT Function

Counts the number of cells that contain numbers.

Step-by-Step Tutorial
  • Select a cell.
  • Type =COUNT(
  • Select a range of cells.
  • Press Enter.
Syntax
COUNT(value1, [value2], ...)
Interactive Demo
Watch the formula in action.
ABCDEFGH
1
2
3
4
5
6
7
8
9
10