Formulas and Functions
ਇਸ ਕੰਟਰੋਲ ਦੀ ਸੋਧ ਕਰਨ ਨਾਲ ਇਹ ਪੰਨਾ ਆਪਣੇ ਆਪ ਅੱਪਡੇਟ ਹੋ ਜਾਵੇਗਾ

SUMXMY2

The SUMXMY2 function returns the sum of the squares of the differences between corresponding values in two collections.

SUMXMY2(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

=SUMXMY2(A1:A6, B1:B6) returns 196, the sum of the squares of the differences of the values in set-1-values (the collection A1:A6) and the values in set-2-values (the collection B1:B6). The formula for the first such difference is (A1 – B1)2 or (2 – 7)2, which is 25.

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.