public class Countifs
extends java.lang.Object
Syntax: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2])
(函数 COUNTIFS 的实现语法: 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))
(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]...) 需要至少 2 个参数并且需要有偶数个参数(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
(在接口 FreeRefFunction 中求值)
args
- the pre-evaluated arguments for this function. args is never
null
, nor are any of its elements.
(args - 此函数的预评估参数。 args 永远不会为空,它的任何元素也不会。)
ec
- primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.
(ec - 主要用于识别包含正在评估的公式的源单元格。也可用于动态创建参考评估。)
null
. Possibly an instance of
ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).
(从不为空。在指定 Excel 错误的情况下可能是 ErrorEval 的一个实例(从不抛出异常来表示 Excel 错误)。)
protected static AreaEval convertRangeArg(ValueEval eval) throws EvaluationException
EvaluationException
(评估异常)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.