org.apache.poi.ss.formula.functions

Class Sumifs

java.lang.Object

org.apache.poi.ss.formula.functions.Sumifs

All Implemented Interfaces:

FreeRefFunction

public final class Sumifs
extends java.lang.Object

Implementation for the Excel function SUMIFS

Syntax :
SUMIFS ( sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

• sum_range Required. One or more cells to sum, including numbers or names, ranges, or cell references that contain numbers. Blank and text values are ignored.
• criteria1_range Required. The first range in which to evaluate the associated criteria.
• criteria1 Required. The criteria in the form of a number, expression, cell reference, or text that define which cells in the criteria_range1 argument will be added
• criteria_range2, criteria2, ... Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.

(Excel 函数 SUMIFS 语法的实现： SUMIFS ( sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) sum_range 必需。一个或多个要求和的单元格，包括数字或名称、范围或包含数字的单元格引用。空白和文本值被忽略。 criteria1_range 必需。评估相关标准的第一个范围。标准1 必需。以数字、表达式、单元格引用或文本形式定义的条件将添加 criteria_range1 参数中的哪些单元格 criteria_range2, criteria2, ... 可选。附加范围及其相关标准。最多允许 127 个范围/标准对。)

Field Summary

Fields

Modifier and Type	Field and Description
static FreeRefFunction	instance Singleton (辛格尔顿)

Constructor Summary

Constructors

Constructor and Description
Sumifs()

Method Summary

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/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b COUNTIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ... (https://support.office.com/en-us/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b COUNTIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

instance

public static final FreeRefFunction instance

Singleton (辛格尔顿)

Constructor Detail

Sumifs

public Sumifs()

Method Detail

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)) (https://support.office.com/en-us/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b COUNTIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ... 至少需要 3参数并且需要有奇数个参数（sum-range plus x*(criteria_range, criteria)）)

Returns:

true if there should be a range argument before the criteria pairs (如果在标准对之前应该有一个范围参数，则为 true)

See Also:

Baseifs.hasInitialRange()

evaluate

public ValueEval evaluate(ValueEval[] args,
                          OperationEvaluationContext ec)

Specified by:

evaluate in interface FreeRefFunction (在接口 FreeRefFunction 中求值)

Parameters:

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 - 主要用于识别包含正在评估的公式的源单元格。也可用于动态创建参考评估。)

Returns:

never 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 错误）。)

convertRangeArg

protected static AreaEval convertRangeArg(ValueEval eval)
                                   throws EvaluationException

Throws:

EvaluationException (评估异常)