Class Countifs
java.lang.Object
org.apache.poi.ss.formula.functions.Countifs
- All Implemented Interfaces:
FreeRefFunction
Implementation for the function COUNTIFS
Syntax: COUNTIFS(criteria_range1, criteria1, [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/COUNTIFS-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842?ui=en-USinvalid input: '&rs'=en-USinvalid input: '&ad'=US COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]...) need at least 2 arguments and need to have an even number of arguments (criteria_range1, criteria1 plus x*(criteria_range, criteria))
-
Field Details
-
instance
Singleton
-
-
Constructor Details
-
Countifs
public Countifs()
-
-
Method Details
-
hasInitialRange
protected boolean hasInitialRange()https://support.office.com/en-us/article/COUNTIFS-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842?ui=en-USinvalid input: '&rs'=en-USinvalid input: '&ad'=US COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]...) need at least 2 arguments and need to have an even number of arguments (criteria_range1, criteria1 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
-