Class Sumproduct
java.lang.Object
org.apache.poi.ss.formula.functions.Sumproduct
- All Implemented Interfaces:
Function
Implementation for the Excel function SUMPRODUCT
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) ) )
Syntax :
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) ) )
- Author:
- Josh Micich
-
Constructor Summary
Constructors -
Method Summary
-
Constructor Details
-
Sumproduct
public Sumproduct()
-
-
Method Details
-
evaluate
- 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
.
-