{"id":15664,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/topx2ay2\/"},"modified":"2021-02-25T16:37:10","modified_gmt":"2021-02-25T16:37:10","slug":"sumx2py2","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/sumx2py2\/","title":{"rendered":"TOPX2AY2"},"content":{"rendered":"

Microsoft Excel ve Google Sheets’te kullan\u0131lan “SUMX2PY2” fonksiyonu, iki veri dizisi i\u00e7indeki kar\u015f\u0131l\u0131kl\u0131 elemanlar\u0131n karelerinin toplam\u0131n\u0131 hesaplar. Bu fonksiyon, \u00f6zellikle istatistiksel analizler ve m\u00fchendislik hesaplamalar\u0131 i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

“SUMX2PY2” fonksiyonunun s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

SUMX2PY2(dizi1, dizi2)<\/code><\/pre>\n
Burada “dizi1” ve “dizi2”, i\u015flem yap\u0131lacak say\u0131 dizilerini ifade eder. Fonksiyon, “dizi1″deki her eleman\u0131n karesi ile “dizi2″deki her eleman\u0131n karesinin toplam\u0131n\u0131 geri d\u00f6nd\u00fcr\u00fcr.<\/p>\n
\u00d6rnek Kullan\u0131m:<\/p>\n
=SUMX2PY2(A1:A5, B1:B5)<\/code><\/pre>\n
Bu \u00f6rnekte, A1’den A5’e ve B1’den B5’e kadar olan h\u00fccrelerdeki say\u0131lar\u0131n kar\u015f\u0131l\u0131kl\u0131 karelerinin toplam\u0131 hesaplanm\u0131\u015ft\u0131r.<\/p>\n
Pratik Uygulamalar<\/h2>\n
Problem 1: \u0130ki Farkl\u0131 Veri Serisinin Kareler Toplam\u0131n\u0131n Hesaplanmas\u0131<\/h3>\n
Farkl\u0131 iki test grubundan al\u0131nan sonu\u00e7lar\u0131n kareler toplam\u0131n\u0131 hesaplamak isteyebilirsiniz. \u00d6rne\u011fin, bir ara\u015ft\u0131rmada iki farkl\u0131 ila\u00e7 kullan\u0131lan iki grup \u00fczerindeki etkiler \u00f6l\u00e7\u00fcl\u00fcp, bu sonu\u00e7lar\u0131n kareleri toplanarak istatistiki bir analiz yap\u0131lacaksa \u015fu \u015fekilde bir form\u00fcl kullanabilirsiniz:<\/p>\n
=SUMX2PY2(A1:A10, B1:B10)<\/code><\/pre>\n
Bu form\u00fcl, A s\u00fctunundaki birinci grup ve B s\u00fctunundaki ikinci grubun sonu\u00e7lar\u0131n\u0131n kareler toplam\u0131n\u0131 hesaplar. Bu hesaplama, istatistiksel analizlerde kullan\u0131lan metriklerden biri olabilir.<\/p>\n
Problem 2: Enerji Verimlili\u011fi Analizi<\/h3>\n
Enerji verimlili\u011fi konusunda \u00e7al\u0131\u015fan m\u00fchendisler, iki farkl\u0131 cihaz\u0131n enerji t\u00fcketim de\u011ferlerinin kareler toplamlar\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rmak isteyebilir. Bu analiz, cihazlar\u0131n enerji verimlili\u011fini de\u011ferlendirme a\u00e7\u0131s\u0131ndan \u00f6nemlidir:<\/p>\n
=SUMX2PY2(C1:C12, D1:D12)<\/code><\/pre>\n
Bu form\u00fcl, C ve D s\u00fctunlar\u0131nda yer alan iki cihaz\u0131n ay baz\u0131nda enerji t\u00fcketim de\u011ferlerinin kareler toplam\u0131n\u0131 hesaplar. Bu de\u011ferler, enerji verimlili\u011fi de\u011ferlendirmesinde kullan\u0131lan \u00f6nemli parametrelerdendir.<\/p>\n
Bu fonksiyonlar sayesinde, Excel ve Google Sheets kullan\u0131larak \u00e7e\u015fitli istatistiksel ve m\u00fchendislik hesaplamalar\u0131 yap\u0131labilir, b\u00fcy\u00fck veri setlerinin \u00fczerinde h\u0131zl\u0131 ve etkili analizler ger\u00e7ekle\u015ftirilmesine imkan verir.<\/p>\n","protected":false},"excerpt":{"rendered":"
\u0130ki dizide kar\u015f\u0131l\u0131k gelen de\u011ferlerin karelerinin toplam\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[577],"tags":[],"class_list":["post-15664","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de SUMX2PY2 (TOPX2AY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SUMX2PY2 (TOPX2AY2) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/sumx2py2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SUMX2PY2 (TOPX2AY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SUMX2PY2 (TOPX2AY2) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/sumx2py2\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:37:10+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de SUMX2PY2 (TOPX2AY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sumx2py2\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/sumx2py2\/\",\"name\":\"Excel'de SUMX2PY2 (TOPX2AY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:37:10+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SUMX2PY2 (TOPX2AY2) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/sumx2py2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/sumx2py2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sumx2py2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matematik ve trigonometri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TOPX2AY2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de SUMX2PY2 (TOPX2AY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SUMX2PY2 (TOPX2AY2) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/tr\/sumx2py2\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SUMX2PY2 (TOPX2AY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SUMX2PY2 (TOPX2AY2) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/sumx2py2\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:37:10+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SUMX2PY2 (TOPX2AY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/sumx2py2\/","url":"https:\/\/functiontranslator.com\/tr\/sumx2py2\/","name":"Excel'de SUMX2PY2 (TOPX2AY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:37:10+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SUMX2PY2 (TOPX2AY2) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/sumx2py2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/sumx2py2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/sumx2py2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Matematik ve trigonometri","item":"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/"},{"@type":"ListItem","position":3,"name":"TOPX2AY2"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15664"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15664\/revisions"}],"predecessor-version":[{"id":26932,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15664\/revisions\/26932"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}