Difference between revisions of "Array Sum"
Jump to navigation
Jump to search
(→Usage) |
|||
Line 1: | Line 1: | ||
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. | 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 == | |
<syntaxhighlight>Array_Sum(ArrayName,StartIndex,EndIndex)</syntaxhighlight> | <syntaxhighlight>Array_Sum(ArrayName,StartIndex,EndIndex)</syntaxhighlight> | ||
− | Where: | + | 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: | 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: | ||
Latest revision as of 21:31, 27 February 2017
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);