Public Function Count( _ ParamArray vValues() As Variant _ ) As Variant
Count(12, 34, 56) = 3 Count(12, 34, Array(56, 78, 90)) = 5 ' Example #2 Count(12, 34, "Joe", Null) = 2 Count(SampleData) = 92See 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.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.