Investment Studio > Expressions > Functions > Statistical > COUNTA

integer counta(data [, ...])

Returns the number of non-empty elements in the argument list. The arguments may include arrays, in which case each non-empty array element is counted individually.

Examples

=counta(1, "", TRUE, "10/5/2002", , , , , )

equals 4. The null string "" may be "empty", but the element which it occupies in the argument list is not (it contains a string, empty or not). The last five arguments on the other hand are empty, and do not contribute to the count.

=counta(1, {"", TRUE, , }, "10/5/2002", , , , , 8)

equals 5 (the non-empty array elements are counted individually).

See also count, countblank, countif, frequency.