Sumproduct (Keikai Spreadsheet Build 6.0.0 API)

java.lang.Object
- org.apache.poi.ss.formula.functions.Sumproduct

All Implemented Interfaces:

ArrayMode, Function
```
public final class Sumproduct
extends Object
implements Function, ArrayMode
```
Implementation for the Excel function SUMPRODUCT
Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]])
Parameter descriptions
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) ) )
The current implementation does not support the more advanced use cases of SUMPRODUCT, including SUMPRODUCT((B2:B9=B12)*(C2:C9=C12)*D2:D9) (see example 3 in https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e).

- Constructor Summary
  
  Constructors
  Constructor Description
  
  Sumproduct()
- Method Summary
  
  All Methods Instance Methods Concrete Methods
  Modifier and Type Method Description
  
  ValueEval evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
  - Methods inherited from class java.lang.Object
    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - Sumproduct
```
public Sumproduct()
```
- Method Detail
  - evaluate
```
public ValueEval evaluate(ValueEval[] args,
                          int srcCellRow,
                          int srcCellCol)
```
    Specified by:
    
    evaluate in interface Function
    
    Parameters:
    
    args - the evaluated function arguments. Empty values are represented with BlankEval or MissingArgEval, never null.
    
    srcCellRow - row index of the cell containing the formula under evaluation
    
    srcCellCol - column index of the cell containing the formula under evaluation
    
    Returns:
    
    The evaluated result, possibly an 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.