SUMX2PY2 - Apple دعم (SA)

Apple‏

"}],"analyticsAttributes":[{"name":"data-analytics-title","value":"ipad"},{"name":"data-analytics-element-engagement","value":"hover - ipad"}]},{"id":"4c4cff9ad8fafe47c7133e474bdde9790a4eee381d459a95caa72dcf75d78fd4","name":"iphone","text":"iPhone","url":"/sa-ar/tv-home/","ariaLabel":"التلفزيون وتطبيق المنزل","submenuAriaLabel":"قائمة التلفزيون وتطبيق المنزل","images":[{"name":"regular","assetInline":""}],"analyticsAttributes":[{"name":"data-analytics-title","value":"tv & home"},{"name":"data-analytics-element-engagement","value":"hover - tv & home"}]},{"id":"f5704204101d75d881e06feb2d08eda4de237cda063cb35a7ea151c75b8b8ddd","name":"entertainment","text":"خدمات الترفيه","url":"/sa-ar/buy/","ariaLabel":"أماكن الشراء","submenuAriaLabel":"قائمة أماكن الشراء","images":[{"name":"regular","assetInline":""}],"analyticsAttributes":[{"name":"data-analytics-title","value":"where to buy"},{"name":"data-analytics-element-engagement","value":"hover - where to buy"}]}],"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":"rtl","searchUrlPath":"n/a","storeRootPath":"","storeUrlPath":"","submenuApiUrl":"https://www.apple.com/api-www/global-elements/global-header/v1/flyouts"},"config":{"version":"ac-globalheader-192-20240507-154002"}}}

مساعدة الصيغ والدوال

جدول المحتويات

تعيين-قيم-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