SUMXMY2()
Syntax. SUMXMY2(array_x,array_y)
Definition. This function returns the sum of squares of differences of corresponding values in two arrays (see Figure 16-37).
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, 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 SUMXMY2() function returns the #N/A
error. The equation for the sum of the squared differences is:
Σ(x – y)2
The solution of this equation is built for the example ...
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.