Class Sumproduct
- java.lang.Object
-
- org.apache.poi.ss.formula.functions.Sumproduct
-
- All Implemented Interfaces:
Function
public final class Sumproduct extends Object implements Function
Implementation for the Excel function SUMPRODUCTSyntax :
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) ) )
-
-
Constructor Summary
Constructors Constructor Description Sumproduct()
-
-
-
Method Detail
-
evaluate
public ValueEval evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
- Specified by:
evaluate
in interfaceFunction
- Parameters:
args
- the evaluated function arguments. Empty values are represented withBlankEval
orMissingArgEval
, nevernull
.srcCellRow
- row index of the cell containing the formula under evaluationsrcCellCol
- column index of the cell containing the formula under evaluation- Returns:
- The evaluated result, possibly an
ErrorEval
, nevernull
. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate toDouble.NaN
be sure to translate the result toErrorEval.NUM_ERROR
.
-
-