SUMX2MY2()
Syntax. SUMX2MY2(array_x,array_y)
Definition. This function returns the sum of the difference of squares of corresponding values in two arrays (see Figure 16-35).
Arguments
array_x (required) The first array or range of values
array_y (required) The second array or range of values
Background. The arguments should be numbers or names, arrays, or references containing numbers.
If an array or a 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, the SUMX2MY2() function returns the #N/A
error.
The equation for the sum of the difference of squares is:
Σ(x2 – y2)
The solution for this equation is built ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.