COUNT

Syntax:

COUNT ( argument-list )

Description: Counts the number of arguments in argument-list that contain numbers, and the number of cells referred to by arguments in argument-list, which contain numbers.

Arguments:

Name

Type

Description

argument-list

text

Each argument in argument-list designates a value. Arguments that are numbers, logical values, dates, or text representations of numbers shall be counted.

If an argument is an array or reference, only numbers in that array or reference shall be counted. Empty cells, logical values, text, or error values in the array or reference shall be ignored.
Note: : To count logical values, text, or error values as well, use the COUNTA
3.17.7.53) function. ]

Return Type and Value: number – The numeric argument and reference to numeric argument count.

example: