|
<< Click to Display Table of Contents >> SUMX2MY2 (sum of x^2 - y^2) |
Syntax:
SUMX2MY2(Range1, Range2)
Description:
Returns the sum of the difference of squares of corresponding values in two arrays.
The equation for this function is:
SUMX2MY2 = ∑(x^2 - y^2)
Range1 and Range2 are the arrays whose SumX2MY2 is to be calculated. As a rule, the cell ranges in which the values are contained must be specified here.
Both ranges must have the same dimensions (height and width), otherwise the function returns a #N/A error value.
Pairs of values where at least one value is an empty cell or a non-numerical value (text string or logical value) are ignored.
Example:
Cells A1 to A3 contain the following values: 9, 4, 7
Cells B1 to B3 contain the following values: 1, 0, 5
If you calculate SUMX2MY2(A1:A3, B1:B3) here, this is equivalent to the following calculation:
(9^2) - (1^2) + (4^2) - (0^2) + (7^2) - (5^2)
The result is 120.
See also: