Difference between revisions of "Array Sum"
(Created page with "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 ...") |
(→Usage) |
||
Line 5: | Line 5: | ||
Where: [[ArrayName]] - an expression specifying the name of an array | Where: [[ArrayName]] - an expression specifying the name of an array | ||
− | |||
− | |||
− | [[EndIndex]] - a numerical expression specifying the ending index for the range | + | [[StartIndex]] - a numerical expression specifying the starting index for the range |
− | + | ||
+ | [[EndIndex]] - a numerical expression specifying the ending index for the range | ||
+ | |||
==== Example ==== | ==== 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: | 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: |
Revision as of 14:54, 20 January 2012
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);