TRY NEW VERSION

SUMSQ

SUMSQ() → { number | string | boolean }

Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names or references to cells that contain numbers.

Parameters:

This method doesn't have any parameters.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.SUMSQ(1, 0, 0, 0, 4, 1, 0, 0, 2, 3, 6, 7, 6, 8, 10, 12));
builder.SaveFile("xlsx", "SUMSQ.xlsx");
builder.CloseFile();

Resulting document