Count Functions

In Excel, the COUNT function is used to count the number of cells that contain numbers in a range. The basic syntax of the COUNT function is as follows:

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


  • value1 is the first value or range that you want to count.
  • [value2] is an optional argument representing additional values or ranges that you want to include in the count.

For example:


This formula will count the number of cells in the range A1:A8 that contain numeric values.