Function Math Statistics Class

Count

Count the number of arguments that are numeric.

Signature (Visual Basic / VBA)

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

Code Example

    Count(12, 34, 56) = 3
    Count(12, 34, Array(56, 78, 90)) = 5 ' Example #2
    Count(12, 34, "Joe", Null) = 2
    Count(SampleData) = 92

Parameters

Parameter Description
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.