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

Implementation for the Excel function AVERAGEIFS

Syntax :

AVERAGEIFS ( average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

min_range Required. One or more cells to average, 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	Averageifs()

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.microsoft.com/en-us/office/averageifs-function-48910c45-1fc0-4389-a028-f7c5c3001690 AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) need at least 3 arguments and need to have an odd number of arguments (average_range plus x*(criteria_range, criteria))

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.microsoft.com/en-us/office/averageifs-function-48910c45-1fc0-4389-a028-f7c5c3001690 AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) need at least 3 arguments and need to have an odd number of arguments (average_range plus x*(criteria_range, criteria))

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

Averageifs	back to summary
public Averageifs()

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.microsoft.com/en-us/office/averageifs-function-48910c45-1fc0-4389-a028-f7c5c3001690 AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) need at least 3 arguments and need to have an odd number of arguments (average_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.

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 Averageifs

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail