public class Countifs
extends java.lang.Object
Syntax: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2])
Modifier and Type | Class and Description |
---|---|
protected static interface |
Baseifs.Aggregator
Implements the details of a specific aggregation function
|
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) |
protected Baseifs.Aggregator |
createAggregator() |
ValueEval |
evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
protected boolean |
hasInitialRange()
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()
,
COUNTIFS functionprotected Baseifs.Aggregator createAggregator()
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 2022 The Apache Software Foundation or its licensors, as applicable.