Examples of org.apache.poi.ss.formula.functions.Sumproduct

Package org.apache.poi.ss.formula.functions

Examples of org.apache.poi.ss.formula.functions.Sumproduct

org.apache.poi.ss.formula.functions.Sumproduct
Implementation for the Excel function SUMPRODUCT
Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]])

array1, ... arrayN typically area references, possibly cell references or scalar values

Let An_(i,j) represent the element in the ith row jth column of the nth array
Assuming each array has the same dimensions (W, H), the result is defined as:
SUMPRODUCT = Σ_{i: 1..H} ( Σ_{j: 1..W} ( Π_{n: 1..N} An_(i,j) ) )
@author Josh Micich

array1, ... arrayN	typically area references, possibly cell references or scalar values

        retval[219] = new Address();  //Aniket Banerjee
        retval[220] = new Days360();
        retval[221] = new Today();


        retval[227] = AggregateFunction.MEDIAN;
        retval[228] = new Sumproduct();
        retval[229] = NumericFunction.SINH;
        retval[230] = NumericFunction.COSH;
        retval[231] = NumericFunction.TANH;
        retval[232] = NumericFunction.ASINH;
        retval[233] = NumericFunction.ACOSH;

View Full Code Here

        retval[219] = new Address();  //Aniket Banerjee
        retval[220] = new Days360();
        retval[221] = new Today();


        retval[227] = AggregateFunction.MEDIAN;
        retval[228] = new Sumproduct();
        retval[229] = NumericFunction.SINH;
        retval[230] = NumericFunction.COSH;
        retval[231] = NumericFunction.TANH;
        retval[232] = NumericFunction.ASINH;
        retval[233] = NumericFunction.ACOSH;

View Full Code Here

TOP

Related Classes of org.apache.poi.ss.formula.functions.Sumproduct

org.apache.poi.ss.formula.eval.AreaEval

org.apache.poi.ss.formula.eval.FunctionEval

org.apache.poi.ss.formula.eval.NumberEval

org.apache.poi.ss.formula.eval.NumericValueEval

org.apache.poi.ss.formula.eval.RefEval

org.apache.poi.ss.formula.eval.ValueEval

org.apache.poi.ss.formula.TwoDEval

org.apache.poi.ss.formula.eval.EvaluationException

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.