Class Countifs

java.lang.Object
org.apache.poi.ss.formula.functions.Countifs
All Implemented Interfaces:
FreeRefFunction

public class Countifs extends Object
Implementation for the function COUNTIFS

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

  • Field Details

  • Constructor Details

    • Countifs

      public Countifs()
  • Method Details

    • hasInitialRange

      protected boolean hasInitialRange()
      https://support.office.com/en-us/article/COUNTIFS-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842?ui=en-US&rs=en-US&ad=US 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:
      true if there should be a range argument before the criteria pairs
      See Also:
      • Baseifs.hasInitialRange()
    • evaluate

      public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec)
      Specified by:
      evaluate in interface FreeRefFunction
      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).
    • convertRangeArg

      protected static AreaEval convertRangeArg(ValueEval eval) throws EvaluationException
      Throws:
      EvaluationException