Class Sumifs
java.lang.Object
org.apache.poi.ss.formula.functions.Sumifs
- All Implemented Interfaces:
FreeRefFunction
Implementation for the Excel function SUMIFS
Syntax :
SUMIFS ( sum_range, criteria_range1, criteria1invalid input: '<'/>,
[criteria_range2, criteria2], ...)
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected static AreaEval
convertRangeArg
(ValueEval eval) evaluate
(ValueEval[] args, OperationEvaluationContext ec) protected boolean
https://support.office.com/en-us/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b COUNTIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...
-
Field Details
-
instance
Singleton
-
-
Constructor Details
-
Sumifs
public Sumifs()
-
-
Method Details
-
hasInitialRange
protected boolean hasInitialRange()https://support.office.com/en-us/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b COUNTIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ... need at least 3 arguments and need to have an odd number of arguments (sum-range plus x*(criteria_range, criteria))- Returns:
- true if there should be a range argument before the criteria pairs
- See Also:
-
evaluate
- Specified by:
evaluate
in interfaceFreeRefFunction
- Parameters:
args
- the pre-evaluated arguments for this function. args is nevernull
, nor are any of its elements.ec
- primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.- Returns:
- never
null
. Possibly an instance of ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).
-
convertRangeArg
- Throws:
EvaluationException
-