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

Sum Function
Math Statistics Class

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

Sum (total) of numeric arguments.

    Sum(12, 34, 56) = 102
    Sum(12, 34, Array(56, 78, 90)) = 270
    Sum(SampleData) = 13354
See also:
    SumArray Function
    Product Function
    SumOfSquares Function
    Count Function
    StatVarType Property
    SUM Function (Microsoft Excel)
vValues: The values that are to be added together. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays, 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 total of the numeric values. Only "atomic" (non-array) elements are added together. Function returns Null if none of the arguments are numeric.

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