SUMIFS

Adds the cells specified by a given set of conditions or criteria.

Syntax

expression.SUMIFS(arg1, arg2, arg3, arg4, arg5);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange | ApiName		The range of cells to be evaluated.
arg2	Required	ApiRange | ApiName | number | string		The first condition or criteria in the form of a number, expression, or text that defines which cells will be added.
arg3	Optional	ApiRange | ApiName		The first range to sum. If omitted, the cells in range are used.
arg4	Required	ApiRange | ApiName | number | string		Up to 127 additional conditions or criteria in the form of a number, expression, or text that defines which cells will be added. These arguments are optional.
arg5	Optional	ApiRange | ApiName		Up to 127 actual ranges to be used to be added. If omitted, the cells in the range are used. These arguments are optional.

Returns

number

Example

This example shows how to add the cells specified by a given set of conditions or criteria.

• Code
• Result

// How to sum up all elements under conditions.

// Use a function to estimate a sum from the cells by a given condition.

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
let year = [2016, 2016, 2016, 2017, 2017, 2017];
let products = ["Apples", "Red apples", "ranges", "Green apples", "Apples", "Bananas"];
let income = ["$100.00", "$150.00", "$250.00", "$50.00", "$150.00", "$200.00"];

for (let i = 0; i < year.length; i++) {
    worksheet.GetRange("A" + (i + 1)).SetValue(year[i]);
}
for (let j = 0; j < products.length; j++) {
    worksheet.GetRange("B" + (j + 1)).SetValue(products[j]);
}
for (let n = 0; n < income.length; n++) {
    worksheet.GetRange("C" + (n + 1)).SetValue(income[n]);
}

let range1 = worksheet.GetRange("C1:C6");
let range2 = worksheet.GetRange("B1:B6");
let range3 = worksheet.GetRange("A1:A6");
worksheet.GetRange("D6").SetValue(func.SUMIFS(range1, range2, "*Apples", range3, 2016));