The COUNT Function: Syntax and Examples

Count function examples and syntax

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.


 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

Example COUNT Function

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!

Leave a Reply

Your email address will not be published. Required fields are marked *