WorksheetFunction.SumX2MY2 Method
Returns the sum of the difference of squares of corresponding values in two arrays.
Syntax
expression.SumX2MY2(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | Array_x - the first array or range of values. |
| Arg2 | Required | Variant | Array_y - the second array or range of values. |
Return Value
Double
Remarks
- The arguments should be either numbers or names, arrays, or references that contain numbers.
- If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
- If array_x and array_y have a different number of values, SUMX2MY2 returns the #N/A error value.
- The equation for the sum of the difference of squares is:
