SUMX2MY2

Sum of the difference of squares of two ranges.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Number

Examples

=SUMX2MY2(A1:A10, B1:B10)

	A	B
1	10	2
2	20	4
3	30	6
4	40	8
5	50	10

Result 5280

Syntax

SUMX2MY2(array_x, array_y)

array_x: range required
array_y: range required

ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.