Spread WPF 17
GrapeCity.CalcEngine.Functions Namespace / CalcSumIfsFunction Class
Members


In This Topic
    CalcSumIfsFunction Class
    In This Topic
    Adds the cells in a range that meet multiple criteria.
    Object Model
    CalcSumIfsFunction Class
    Syntax
    'Declaration
     
    Public Class CalcSumIfsFunction 
       Inherits CalcBuiltinFunction
    'Usage
     
    Dim instance As CalcSumIfsFunction
    public class CalcSumIfsFunction : CalcBuiltinFunction 
    Remarks
    The order of arguments is different between SUMIFS and SUMIF. In particular, the sum_range argument is the first argument in SUMIFS, but it is the third argument in SUMIF. If you are copying and editing these similar functions, make sure you put the arguments in the correct orde.
    Inheritance Hierarchy

    System.Object
       GrapeCity.CalcEngine.Functions.CalcFunction
          GrapeCity.CalcEngine.Functions.CalcBuiltinFunction
             GrapeCity.CalcEngine.Functions.CalcSumIfsFunction

    See Also