SUMXMY2 Function Explained
The SUMXMY2 Function in Microsoft Excel calculates the sum of the differences between two arrays of numbers. It takes two arrays of the same size as arguments and subtracts the corresponding elements of each array from each other, then adds up all the differences. The result is the sum of the differences between the two arrays.
SUMXMY2 Function Syntax
SUMXMY2(array1, array2)
- array1: The first array of numbers to be added and then subtracted from the second array.
- array2: The second array of numbers to be subtracted from the first array.