The COUNT function
Counts the cells that contain a number, or a date. Text, even "12", does not count.
Syntax
=COUNT(value1, [value2], …)
In a French Excel: =NB(valeur1; [valeur2]; …).
Arguments
- value1, value2…: cells or ranges.
An example
=COUNT(C2:C500)
The number of amounts entered in column C.
Pitfalls
- Numbers stored as text are not counted.
- To count non-empty cells, use COUNTA.
Going further
Frequently asked questions
- Does COUNT count dates?
- Yes: a date is a number for Excel.