CALC.sumif(Array1, ConditionString, array2)

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) >>