Formulas and Functions
இந்தக் கட்டுப்பாட்டை மாற்றினால் இந்தப் பக்கம் தானாக மாற்றப்படும்

SUMX2MY2

The SUMX2MY2 function returns the sum of the difference of the squares of corresponding values in two collections.

SUMX2MY2(set-1-values, set-2-values)

set-1-values: A collection containing the first set of number values.

set-2-values: A collection containing the second set of number values.

Example

Given the following table:

A

B

1

2

7

2

9

5

3

3

6

4

11

8

5

1

12

6

5

9

=SUMX2MY2(A1:A6, B1:B6) returns -158, the sum of the differences of the squares of the values in set-1-values (the collection A1:A6) and the squares of the values in set-2-values (the collection B1:B6). The formula for the first such difference is A12 - B12 or 4 - 49, which is -45.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
உதவியாக இருந்ததா?
எழுத்தின் அளவு: 250
அதிகபட்ச எழுத்தின் அளவு: 250
உங்கள் கருத்திற்கு நன்றி.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.