public class Countifs
extends java.lang.Object
Syntax: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2])
Modifier and Type | Field and Description |
---|---|
static FreeRefFunction |
instance
Singleton
|
Constructor and Description |
---|
Countifs() |
Modifier and Type | Method and Description |
---|---|
protected static AreaEval |
convertRangeArg(ValueEval eval) |
ValueEval |
evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
protected boolean |
hasInitialRange()
https://support.office.com/en-us/article/COUNTIFS-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842?ui=en-US&rs=en-US&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))
|
public static final FreeRefFunction instance
protected boolean hasInitialRange()
Baseifs.hasInitialRange()
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec)
evaluate
in interface FreeRefFunction
args
- the pre-evaluated arguments for this function. args is never null
,
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.null
. Possibly an instance of ErrorEval in the case of
a specified Excel error (Exceptions are never thrown to represent Excel errors).protected static AreaEval convertRangeArg(ValueEval eval) throws EvaluationException
EvaluationException
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.