The **COUNT** is an Excel statistical function that counts how many numbers are in a list of arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003.

**Note: ** If you want to count logical values, text, or error values, use the **COUNTA** function. And for numbers that meet a certain criteria, use the **COUNTIF** or the **COUNTIFS** function.

## Syntax

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

## Required Arguments

**value1**: Arguments can either be numbers or names, arrays, or references that contain numbers, which means 3, B7 and C2:C6 are all valid examples.

## Optional Arguments

**value2-255**: You can use up to 255 additional items, cell references, or ranges in the calculation by following the syntax listed above.

**Note: ** The arguments can contain or refer to a variety of different types of data, but only numbers are counted.

## COUNT Function Examples

As seen in the above screenshot, the COUNT function will only count numerical values, such as number, date, currency. You can reference the cells individually, within a range, or add values directly as arguments to the function itself. In the above case – 98.

Also note that blank cells, errors and text will not be counted!

## More Examples and Use Cases

We don’t have any use cases for this formula on our website at this moment but will link them below once we have. Stay tuned!