CalcSumIfsFunction Class

Adds the cells in a range that meet multiple criteria.

Object Model

Syntax

Visual Basic
C#

'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

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

CalcSumIfsFunction Members
GrapeCity.CalcEngine.Functions Namespace