Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: SUMXMY2 function

SUMXMY2 function: Description, Usage, Syntax, Examples and Explanation

What is SUMXMY2 function in Excel? SUMXMY2 function is one of the Math and Trig functions in Microsoft Excel that returns the sum of squares of differences of corresponding values in two arrays. Syntax of SUMXMY2 function SUMXMY2(array_x, array_y) The SUMXMY2 function syntax has the following arguments: Array_x: The first array or range of values. Array_y:    Required. The second array…