Array Sum

Returns a sum of the values contained in a range of elements, specified by the starting and ending indexes, of the specified one-dimensional array; returns the number of true elements if the array contains true/false values; returns a value of 0 if the array contains string values.

Usage

Array_Sum(ArrayName,StartIndex,EndIndex)

Where:

ArrayName - an expression specifying the name of an array

StartIndex - a numerical expression specifying the starting index for the range

EndIndex - a numerical expression specifying the ending index for the range

Example

Assign a value, indicating a sum of the values contained in the segment of Array1 that begins at the index of 4 and ends at the index of 6, to Value1 variable:

Value1=Array_Sum(Array1,4,6);