{"id":15665,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/topxey2\/"},"modified":"2021-02-25T16:37:11","modified_gmt":"2021-02-25T16:37:11","slug":"sumxmy2","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/sumxmy2\/","title":{"rendered":"TOPXEY2"},"content":{"rendered":"

Excel ve Google Sheets, veri analizi ve hesaplamalar\u0131 kolayla\u015ft\u0131ran bir dizi kullan\u0131\u015fl\u0131 i\u015flev sunar. Bu yaz\u0131da, SUMXMY2 (Excel’de) ve TOPXEY2 (Google Sheets’te) i\u015flevlerinin kullan\u0131m\u0131n\u0131 anlataca\u011f\u0131m. Bu i\u015flevler, iki dizide yer alan kar\u015f\u0131l\u0131k gelen de\u011ferlerin farklar\u0131n\u0131n karelerinin toplam\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. \u0130statistiksel analizler ve hata karelerinin hesaplanmas\u0131nda \u00f6zellikle yararl\u0131d\u0131rlar.<\/p>\n

\u0130\u015flevin S\u00f6zdizimi ve Kullan\u0131m \u00d6rnekleri<\/h2>\n

SUMXMY2 ve TOPXEY2 i\u015flevlerinin s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=SUMXMY2(array1, array2)<\/code><\/pre>\n
    \n
  • array1:<\/strong> \u0130lk diziyi temsil eder ve karesi al\u0131nacak farklar buradan hesaplan\u0131r.<\/li>\n
  • array2:<\/strong> \u0130kinci diziyi temsil eder ve array1 ile ayn\u0131 boyutta olmal\u0131d\u0131r.<\/li>\n<\/ul>\n
    Bir \u00f6rnek \u00fczerinden gidelim: \u0130ki sat\u0131\u015f ekibinin ayn\u0131 \u00fcr\u00fcnler \u00fczerindeki sat\u0131\u015f performanslar\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rmak istiyoruz. Veriler \u015f\u00f6yledir:<\/p>\n\n\n\n\n\n\n
    Ay<\/th>\nEkib A Sat\u0131\u015flar\u0131<\/th>\nEkib B Sat\u0131\u015flar\u0131<\/th>\n<\/tr>\n
    Ocak<\/td>\n200<\/td>\n150<\/td>\n<\/tr>\n
    \u015eubat<\/td>\n150<\/td>\n180<\/td>\n<\/tr>\n
    Mart<\/td>\n300<\/td>\n300<\/td>\n<\/tr>\n
    Nisan<\/td>\n250<\/td>\n220<\/td>\n<\/tr>\n<\/table>\n
    Excel i\u00e7in bu verilerle ilgili form\u00fcl \u015f\u00f6yledir:<\/p>\n
    =SUMXMY2(A2:A5, B2:B5)<\/code><\/pre>\n
    Google Sheets’te kullan\u0131m\u0131 ise ayn\u0131d\u0131r:<\/p>\n
    =TOPXEY2(A2:A5, B2:B5)<\/code><\/pre>\n
    Bu form\u00fcller, her iki ekip aras\u0131ndaki ayl\u0131k sat\u0131\u015f farklar\u0131n\u0131n karelerinin toplam\u0131n\u0131 hesaplar.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    1. Performans De\u011ferlendirme:<\/strong> Bir \u015firketin y\u0131ll\u0131k sat\u0131\u015f hedefleri ile ger\u00e7ekle\u015fen sat\u0131\u015flar\u0131n kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131:<\/p>\n\n\n\n\n\n\n
    Ay<\/td>\nHedef Sat\u0131\u015flar<\/td>\nGer\u00e7ekle\u015fen Sat\u0131\u015flar<\/td>\n<\/tr>\n
    Ocak<\/td>\n120<\/td>\n150<\/td>\n<\/tr>\n
    \u015eubat<\/td>\n130<\/td>\n120<\/td>\n<\/tr>\n
    Mart<\/td>\n200<\/td>\n220<\/td>\n<\/tr>\n
    Nisan<\/td>\n170<\/td>\n160<\/td>\n<\/tr>\n<\/table>\n
    SUMXMY2 ve TOPXEY2 kullanarak, hedef ve ger\u00e7ekle\u015fen sat\u0131\u015flar aras\u0131ndaki farklar\u0131n karelerinin toplanmas\u0131 yap\u0131l\u0131r; bu, hedef sapmalar\u0131n\u0131 net bir \u015fekilde g\u00f6sterir:<\/p>\n
    =SUMXMY2(B2:B5, C2:C5)<\/code><\/pre>\n
    2. \u0130ki Grup Aras\u0131ndaki Uyumsuzluk \u00d6l\u00e7\u00fcm\u00fc:<\/strong> \u0130ki laboratuvar\u0131n benzer deneylerdeki sonu\u00e7lar\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rma:<\/p>\n\n\n\n\n\n\n
    Deney<\/td>\nLab A Sonu\u00e7lar\u0131<\/td>\nLab B Sonu\u00e7lar\u0131<\/td>\n<\/tr>\n
    1<\/td>\n50<\/td>\n45<\/td>\n<\/tr>\n
    2<\/td>\n60<\/td>\n65<\/td>\n<\/tr>\n
    3<\/td>\n55<\/td>\n53<\/td>\n<\/tr>\n
    4<\/td>\n70<\/td>\n68<\/td>\n<\/tr>\n<\/table>\n
    Bu sonu\u00e7larla, i\u015flevler laboratuvarlar aras\u0131ndaki sonu\u00e7 farkl\u0131l\u0131klar\u0131n\u0131 say\u0131sal olarak ifade eder, b\u00f6ylece y\u00f6neticiler kalite kontrol s\u00fcre\u00e7lerinde bu bilgileri kullanabilirler:<\/p>\n
    =SUMXMY2(B2:B5, C2:C5)<\/code><\/pre>\n
    \n
    Bu yaz\u0131da a\u00e7\u0131klanan SUMXMY2 ve TOPXEY2 i\u015flevleri, iki dizideki veriler aras\u0131ndaki farklar\u0131n kareleri toplam\u0131n\u0131 hesaplamakta kullan\u0131l\u0131r ve istatistiksel analizler ile veri setleri aras\u0131ndaki farkl\u0131l\u0131klar\u0131 de\u011ferlendirmede etkili ara\u00e7lard\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ki dizide kar\u015f\u0131l\u0131k gelen de\u011fer fark\u0131 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-15665","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de SUMXMY2 (TOPXEY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SUMXMY2 (TOPXEY2) 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\/sumxmy2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SUMXMY2 (TOPXEY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SUMXMY2 (TOPXEY2) 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\/sumxmy2\/\" \/>\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:11+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 SUMXMY2 (TOPXEY2) 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\/sumxmy2\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/sumxmy2\/\",\"name\":\"Excel'de SUMXMY2 (TOPXEY2) 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:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SUMXMY2 (TOPXEY2) 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\/sumxmy2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/sumxmy2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/sumxmy2\/#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\":\"TOPXEY2\"}]},{\"@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 SUMXMY2 (TOPXEY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SUMXMY2 (TOPXEY2) 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\/sumxmy2\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SUMXMY2 (TOPXEY2) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SUMXMY2 (TOPXEY2) 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\/sumxmy2\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:37:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SUMXMY2 (TOPXEY2) 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\/sumxmy2\/","url":"https:\/\/functiontranslator.com\/tr\/sumxmy2\/","name":"Excel'de SUMXMY2 (TOPXEY2) 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:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SUMXMY2 (TOPXEY2) 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\/sumxmy2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/sumxmy2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/sumxmy2\/#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":"TOPXEY2"}]},{"@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\/15665","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=15665"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15665\/revisions"}],"predecessor-version":[{"id":26933,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15665\/revisions\/26933"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}