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:
evaluatein interfaceFunction- Parameters:
args- the evaluated function arguments. Empty values are represented withBlankEvalorMissingArgEval, 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.NaNbe sure to translate the result toErrorEval.NUM_ERROR.
-