Function Math Statistics Class

Sum

Sum (total) of numeric arguments.

Signature (Visual Basic / VBA)

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

Code Example

    Sum(12, 34, 56) = 102
    Sum(12, 34, Array(56, 78, 90)) = 270
    Sum(SampleData) = 13354

Parameters

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