CALC.sumif(Array1, ConditionString, array2)
CALC.ceiling(number, significance)
CALC.combin(totalnumber, groupnumber)
CALC.floor(number, SIgnificance)
CALC.quotient(numerator, denominator)
CALC.round(number, num_digits)
CALC.rounddown(number, num_digits)
CALC.roundup(number, num_digits)
CALC.seriessum(x, n, m, coefficients)
CALC.subtotal(functionnumber, array)
Returns the sum of the elements in an array based on the values of another array specified by a condition. Array1 is the array whose values will be checked based on the condition specified. Conditionstring is the condition ('> 30000', '=4000', '<3500'). Array2 is the array whose values (corresponding to array1) will be summed.
Example
CALC.sumif([10,25,30,15,45], '> 20',[1,2,3,4,5]);
// returns 10
(This only sums those values of array2 where the corresponding values of array1 are greater than 20.)
| << CALC.sum(Array) | © 1996-2013 InetSoft Technology Corporation (v11.5) | CALC.sumproduct(2DArray) >> |