Top Description Fields Constructors Methods
org.apache.poi.ss.formula.functions

public Class Countifs

extends Baseifs
Class Inheritance
Imports
org.apache.poi.ss.formula.eval.NumberEval, .ValueEval
Implementation for the function COUNTIFS

Syntax: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2])

Field Summary

Modifier and TypeField and Description
public static final FreeRefFunction
instance

Singleton

Constructor Summary

AccessConstructor and Description
public
Countifs()

Method Summary

Modifier and TypeMethod 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.

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))

Inherited from org.apache.poi.ss.formula.functions.Baseifs:
convertRangeArgevaluate

Field Detail

instanceback to summary
public static final FreeRefFunction instance

Singleton

Constructor Detail

Countifsback to summary
public Countifs()

Method Detail

createAggregatorback to summary
protected Baseifs.Aggregator createAggregator()

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

Annotations
@Override
hasInitialRangeback to summary
protected boolean hasInitialRange()

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

Returns:boolean

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

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

See Also
org.apache.poi.ss.formula.functions.Baseifs#hasInitialRange(), COUNTIFS function