Apache POI - Common 5.3.0 · org.apache.poi.ss.formula.functions.Sumifs

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.

Modifier and Type	Field and Description
public static final FreeRefFunction	instance Singleton

Access	Constructor and Description
public	Sumifs()

Method Summary

Modifier and Type	Method and Description
protected Baseifs.Aggregator	createAggregator() Implements abstract org.apache.poi.ss.formula.functions.Baseifs.createAggregator.
protected boolean	hasInitialRange() Implements abstract org.apache.poi.ss.formula.functions.Baseifs.hasInitialRange. https://support.office.com/en-us/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b COUNTIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...

Inherited from org.apache.poi.ss.formula.functions.Baseifs:: convertRangeArg evaluate

Field Detail

instance	back to summary
public static final FreeRefFunction instance Singleton

Constructor Detail

Sumifs	back to summary
public Sumifs()

Method Detail

createAggregator	back to summary
protected Baseifs.Aggregator createAggregator() Implements abstract org.apache.poi.ss.formula.functions.Baseifs.createAggregator. Annotations @Override

createAggregator

back to summary

protected Baseifs.Aggregator createAggregator()

Implements abstract org.apache.poi.ss.formula.functions.Baseifs.createAggregator.

Annotations

@Override

hasInitialRange	back to summary
protected boolean hasInitialRange() Implements abstract org.apache.poi.ss.formula.functions.Baseifs.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)) Returns:boolean Doc from org.apache.poi.ss.formula.functions.Baseifs.hasInitialRange. true if there should be a range argument before the criteria pairs Annotations @Override

hasInitialRange

back to summary

protected boolean hasInitialRange()

Implements abstract org.apache.poi.ss.formula.functions.Baseifs.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))

Returns:boolean

Doc from org.apache.poi.ss.formula.functions.Baseifs.hasInitialRange.

true if there should be a range argument before the criteria pairs

Annotations

@Override

public final Class Sumifs

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail