Examples of Sumif

org.apache.poi.ss.formula.functions.Sumif

Implementation for the Excel function SUMIF

Syntax :
SUMIF ( range, criteria, sum_range )

range	The range over which criteria is applied. Also used for addend values when the third parameter is not present
criteria	The value or expression used to filter rows from range
sum_range	Locates the top-left corner of the corresponding range of addends - values to be added (after being selected by the criteria)

@author Josh Micich

org.boris.expr.function.excel.SUMIF

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


        retval[342] = NumericFunction.RADIANS;
        retval[343] = NumericFunction.DEGREES;


        retval[344] = new Subtotal();
        retval[345] = new Sumif();
        retval[346] = new Countif();
        retval[347] = new Countblank();


        retval[354] = new Roman();

View Full Code Here

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


        retval[342] = NumericFunction.RADIANS;
        retval[343] = NumericFunction.DEGREES;


        retval[344] = new Subtotal();
        retval[345] = new Sumif();
        retval[346] = new Countif();
        retval[347] = new Countblank();


        retval[354] = new Roman();

View Full Code Here

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

    public void testSUM() throws Exception {
        assertResult("sum(34,45)", 79.);
    }


    public void testSUMIF() throws Exception {
        AbstractFunction s = new SUMIF();
        assertEquals(eval(s, toArray(1, 2, 3), ">2"), 3.);
        assertEquals(eval(s, toArray(1.658, 1.656, 1.657), "<1.657"), 1.656);
        assertEquals(eval(s, toArray(1, 2, 3), "<=2"), 3.);
        assertEquals(eval(s, toArray(1, 2, 3), ">=2"), 5.);
        assertEquals(eval(s, toArray("apples", 2, 3), "apples", toArray(4.5)),

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.