Investment Studio > Expressions > Functions > Statistical > COUNT

integer count(data [, ...])

Returns the number of elements in the argument list that can be interpreted as numbers using the standard rules of type conversion. The argument list may contain arrays, in which case each array element is converted and counted individually.

Examples

Assuming standard US date format settings,

=count(1, "Rambo", TRUE, "10/5/2002")

and

=count(1, {"Rambo", TRUE}, "10/5/2002")

both equal 3 (1 is a number, TRUE evaluates to the integer 1, "10/5/2002" evaluates to the float 37534; "Rambo" can not be interpreted as a number).

See also counta, countblank, countif, frequency.