COUNT function - Function that counts cells containing numbers in the list of arguments in Excel

The following article introduces you to the COUNT function - 1 of the functions in the statistical function group is very popular in Excel.

COUNT function - Function that counts cells containing numbers in the list of arguments in Excel Picture 1

Description: The function performs counting cells that contain numbers in the list of arguments.

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

Inside:

- value1, value2: List of values, cell ranges or references that want to count, where value1 is a required parameter, the remaining value values are arbitrary and contain up to 255 value values .

Attention:

- Arguments with numbers, dates, or text representations of numbers will be counted.

- When typing logical values ​​or text numbers directly into the function, they are counted .

- If the argument is an array or reference, only numerical values ​​are counted, logical values ​​and text are ignored.

- In case you want to count logical values ​​and text or error values ​​-> use the COUNTA function .

- To count values ​​that meet certain conditions -> use the COUNTIF or COUNTIFS functions .

For example:

Counts the number of cells that contain numeric values ​​of the values ​​in the table below:

COUNT function - Function that counts cells containing numbers in the list of arguments in Excel Picture 2

- In the cell to calculate, enter the formula: = COUNT (D6: D10)

COUNT function - Function that counts cells containing numbers in the list of arguments in Excel Picture 3

- Press Enter -> the number of cells containing numeric values ​​is:

COUNT function - Function that counts cells containing numbers in the list of arguments in Excel Picture 4

- In the data sheet above the text value is not counted, and the date value is still calculated.

- Where the values ​​are logical values ​​and error values ​​-> functions are ignored:

COUNT function - Function that counts cells containing numbers in the list of arguments in Excel Picture 5

Above are instructions and some specific examples when using the COUNT function in Excel.

Good luck!