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!