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

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

Examples of org.apache.poi.ss.formula.functions.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


        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


        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

TOP

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

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.ValueEval

org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate

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.