Class Sumif

  • All Implemented Interfaces:
    Function, Function2Arg, Function3Arg

    public final class Sumif
    extends java.lang.Object
    Implementation for the Excel function SUMIF

    Syntax :
    SUMIF ( range, criteria, sum_range )

    rangeThe range over which criteria is applied. Also used for addend values when the third parameter is not present
    criteriaThe value or expression used to filter rows from range
    sum_rangeLocates the top-left corner of the corresponding range of addends - values to be added (after being selected by the criteria)