SUMX2PY2 - Apple 支援 (澳門)

Apple

"}],"analyticsAttributes":[{"name":"data-analytics-title","value":"support"},{"name":"data-analytics-element-engagement","value":"hover - support"},{"name":"data-analytics-exit-link","value":"true"}]}],"segmentbar":{"dataStrings":{}},"menu":{"open":{"ariaLabel":"選單"},"close":{"ariaLabel":"關閉"},"back":{"ariaLabel":"主選單","images":[{"name":"compact","assetInline":""}]}},"submenu":{"open":{"images":[{"name":"regular","assetInline":""},{"name":"compact","assetInline":""}]}},"hasAbsoluteUrls":true,"hasShopRedirectUrls":false,"analyticsType":"support","storeApiKey":"","wwwDomain":"www.apple.com","textDirection":"ltr","searchUrlPath":"","storeRootPath":"","storeUrlPath":"","submenuApiUrl":"https://www.apple.com/api-www/global-elements/global-header/v1/flyouts"},"config":{"version":"ac-globalheader-192-20240507-154002"}}}

Formulas and Functions

選取版本：

修改此控制項目會使頁面自動更新

第 2 個數值集合： 包含第二組數字值的集合。

範例
提供下列表格：

	A	B
1	2	7
2	9	5
3	3	6
4	11	8
5	1	12
6	5	9

=SUMX2PY2(A1:A6, B1:B6) 會傳回 640，此為第 1 個數值集合（集合 A1:A6）中的值平方與第 2 個數值集合（集合 B1:B6）的值平方加總。第一個此類總和的公式是 A1² + B1² 或 4 + 49，其為 53。

有幫助？

Follow Lee on X/Twitter - Father, Husband, Serial builder creating AI, crypto, games & web tools. We are friends :) AI Will Come To Life!

Check out: eBank.nz (Art Generator) | Netwrck.com (AI Tools) | Text-Generator.io (AI API) | BitBank.nz (Crypto AI) | ReadingTime (Kids Reading) | RewordGame | BigMultiplayerChess | WebFiddle | How.nz | Helix AI Assistant