Adds the cells in a range that meet multiple criteria.
Object Model
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
Requirements
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)
See Also