SUMXMY2

Formulas / SUMXMY2
Calculate 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?
The SUMXMY2 function returns the sum of squares of differences of corresponding values in two arrays.
What type of arguments does SUMXMY2 take?
The arguments for SUMXMY2 should contain numbers.
Does SUMXMY2 ignore certain types of values?
Yes, SUMXMY2 ignores text, logical values, and empty cells in the arguments.
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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV