|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.poi.hssf.record.formula.functions.Sumif
public final class 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) |
Constructor Summary | |
---|---|
Sumif()
|
Method Summary | |
---|---|
Eval |
evaluate(Eval[] args,
int srcRowIndex,
short srcColumnIndex)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public Sumif()
Method Detail |
---|
public Eval evaluate(Eval[] args, int srcRowIndex, short srcColumnIndex)
evaluate
in interface Function
args
- the evaluated function arguments. Elements of this array typically implement
ValueEval
. Empty values are represented with BlankEval
or MissingArgEval
, never null
.srcRowIndex
- row index of the cell containing the formula under evaluationsrcColumnIndex
- column index of the cell containing the formula under evaluation
ErrorEval
, never null
.
Note - Excel uses the error code #NUM! instead of IEEE NaN, so when
numeric functions evaluate to Double.NaN
be sure to translate the result to ErrorEval.NUM_ERROR
.
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |