CALC.subtotal(functionnumber, array)

Returns the subtotal of an array based on the specified function number. 1 = average, 2 = count, 3 = counta, 4 = max, 5 = min, 6 = product, 7 = stdev, 8 = stdevp, 9 = sum, 10 = var, 11 = varp.

Example

CALC.subtotal(1, [1,2,3]);

// returns 2

<< CALC.sqrtpi(number) © 1996-2013 InetSoft Technology Corporation (v11.5) CALC.sum(Array) >>