SUMSQ
Returns the sum of the squares of the arguments.
Syntax
expression.SUMSQ(args);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| args | Required | ApiRange | ApiName | number | string | boolean | (number | string | boolean)[] | Up to 255 numeric values for which the sum of the squares will be calculated.\ The first argument is required, subsequent arguments are optional.\ The arguments can be numbers, names, logical values or text representations of numbers, ranges of cells that contain numbers, or arrays. |
Returns
number
Example
- Code
- Result
let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.SUMSQ(1, 0, 0, 0, 4, 1, 0, 0, 2, 3, 6, 7, 6, 8, 10, 12));