|
||||||||||
| 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 Functionargs - 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 | |||||||||