<-- Previous || Up || Next -->

Count Function
Math Statistics Class

Public Function Count( _
    ParamArray vValues() As Variant _
    ) As Variant

Count the number of arguments that are numeric.

    Count(12, 34, 56) = 3
    Count(12, 34, Array(56, 78, 90)) = 5 ' Example #2
    Count(12, 34, "Joe", Null) = 2
    Count(SampleData) = 92
See also:
    CountEqual Function
    Sum Function
    StatVarType Property
    COUNT Function (Microsoft Excel)
    COUNTA Function (Microsoft Excel)
vValues: The values that are to be counted. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays (as in Example #2), or any combination of these. The current setting of the StatVarType Property determines which numeric data types are recognized by this function.
Return value: Function returns a count of the numeric values. Only "atomic" (non-array) elements are counted. Function returns 0 (zero) if none of the arguments are numeric.

Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.