SUMX2MY2
Formulas / SUMX2MY2Calculate the sum of the squares of differences of corresponding values in two arrays.
SUMX2MY2(array_x, array_y)
- array_x - required, first set of numbers in a range or array
- array_y - required, second range of numbers
Examples
=SUMX2MY2(A2:A8,B2:B8)The SUMX2MY2 function can be used to calculate the sum of the difference of squares of two arrays. For example, to calculate the sum of the difference of squares of two arrays A2:A8 and B2:B8, the formula used would be the same as above. This formula returns the sum of the difference of squares of the two arrays.
=SUMX2MY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})The SUMX2MY2 function can also be used to calculate the sum of the squares of two constant arrays.This formula returns the sum of the squares of the two constant arrays.
Summary
The SUMX2MY2 function calculates the sum of the difference of the squares of two arrays of numbers. It only accepts numeric values and ignores text, logical values, and empty cells.
- The SUMX2MY2 function returns the sum of the squares of the differences of corresponding values in two arrays.
- The arguments for SUMX2MY2 must be of the same size, and can be constants, cell references, or ranges.
Frequently Asked Questions
What is the SUMX2MY2 function?
The SUMX2MY2 function returns the sum of the difference of squares of corresponding values in two arrays.
What arguments does the SUMX2MY2 function take?
The SUMX2MY2 function takes two arrays as arguments.
What values does the SUMX2MY2 function ignore?
The SUMX2MY2 function ignores text, logical values, and empty cells in the arguments.
