Examples of 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
org.boris.expr.function.excel.SUMPRODUCT

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

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

        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

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

        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

Examples of org.boris.expr.function.excel.SUMPRODUCT

        assertEquals(eval(s, toArray(1, 2.5, 3), "=2.5", toArray(3, 2, 1)), 2.);
        assertEquals(eval(s, toArray(1, 2.5, 3), 1, toArray(3, 2, 1)), 3.);
    }


    public void testSUMPRODUCT() throws Exception {
        SUMPRODUCT s = new SUMPRODUCT();
        assertEquals(eval(s, toArray(1, 2, 3), toArray(4, 5, 6)), 32.);
        assertEquals(eval(s, toArray(3., 8, 1, 4., 6, 9), toArray(2, 6, 5, 7,
                7, 3)), 156.);
    }

View Full Code Here

TOP

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.