SUMXMY2
Formulas / SUMXMY2Calculate the sum of squares of differences between corresponding values in two arrays.
SUMXMY2(Array1, Array2)
- array_x - required, first array or range of values
- array_y - required, second array or range of values
Examples
=SUMXMY2(A3:A9,B3:B9)The SUMXMY2 function can be used to calculate the sum of squares of differences between two arrays. In this example, we will calculate the sum of squares of differences between two arrays of numbers: A3:A9 and B3:B9. The result of this calculation will be the sum of the squares of the differences between the values in the two arrays.
=SUMXMY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})The SUMXMY2 function can also be used to calculate the sum of squares of differences between two constants. Here, we will calculate the sum of squares of differences between two constants, {2, 3, 9, 1, 8, 7, 5} and {6, 5, 11, 7, 5, 4, 4}. The result of this calculation will be the sum of the squares of the differences between the values in the two constants.
=SUMXMY2(B2:B6,C2:C6)The SUMXMY2 function can also be used to calculate the sum of squares of differences between two ranges. Here, we will calculate the sum of squares of differences between two ranges, B2:B6 and C2:C6. The result of this calculation will be the sum of the squares of the differences between the values in the two ranges.
Summary
The SUMXMY2 function calculates the sum of the squares of the differences between corresponding values in two arrays or references. It can only use numerical values and ignores text, logical values and empty cells.
- The SUMXMY2 function calculates the sum of squares of differences between corresponding values in two arrays. The arguments for SUMXMY2 are array_x and array_y, which can be provided as an array constant or as a range.
- The array_x argument is the first set of numbers in a range or array, while the array_y argument is the second range of numbers.
- SUMXMY2 throws a #N/A error if the arrays have different numbers of cells.
Frequently Asked Questions
What is the SUMXMY2 function?
What type of arguments does SUMXMY2 take?
Does SUMXMY2 ignore certain types of values?
What should I watch out for when using SUMXMY2?
- Make sure that you are entering numbers as arguments.
- Be aware that SUMXMY2 ignores text, logical values, and empty cells in the arguments.
- Ensure that you have the same number of arguments for each array.
