Countifs (POI API Documentation)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.apache.poi.ss.formula.functions
Class Countifs

java.lang.Object
  org.apache.poi.ss.formula.functions.Countifs

Implementation for the function COUNTIFS

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

Field Summary
`static FreeRefFunction`	`instance`

Constructor Summary
`Countifs()`

Method Summary
`ValueEval`	`evaluate(ValueEval[] args, OperationEvaluationContext ec)`

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Field Detail

public static final FreeRefFunction instance

Constructor Detail

public Countifs()

Method Detail

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

Parameters:: args - the pre-evaluated arguments for this function. args is never null, nor are any of its elements.; ec - primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.
Returns:: never null. Possibly an instance of ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).