{"id":7276,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/summex2my2\/"},"modified":"2021-02-25T16:11:46","modified_gmt":"2021-02-25T16:11:46","slug":"sumx2my2","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/de\/sumx2my2\/","title":{"rendered":"SUMMEX2MY2"},"content":{"rendered":"

\u00dcberblick und Syntax<\/h2>\n

Die Funktion SUMX2MY2<\/code> ist besonders n\u00fctzlich in der statistischen Analyse und findet h\u00e4ufig Anwendung in den Bereichen Finanzwesen und Ingenieurwesen. Sie berechnet die Summe der Differenzen der Quadrate zweier Datens\u00e4tze. In Google Sheets wird diese Funktion als SUMMEX2MY2<\/code> bezeichnet.<\/p>\n

Die Syntax der Funktion lautet wie folgt:<\/p>\n

 In Excel: =SUMX2MY2(Array1, Array2)<\/code> In Google Tabellen: =SUMMEX2MY2(Array1, Array2)<\/code> <\/pre>\n
Die Parameter Array1<\/code> und Array2<\/code> sind die Arrays oder Zellbereiche, deren Werte jeweils quadriert und deren Ergebnisse anschlie\u00dfend voneinander subtrahiert werden, um die Summe dieser Differenzen zu ermitteln.<\/p>\n
Praktische Anwendungsf\u00e4lle<\/h2>\n
Beispiel 1: Vergleich von Produktionskosten<\/h2>\n
Ein Unternehmen will die Unterschiede in den quadrierten Produktionskosten zweier Produkte \u00fcber mehrere Monate hinweg analysieren, um Einsichten in die Variabilit\u00e4t ihrer Kostenstrukturen zu gewinnen.<\/p>\n
    \n
  • \n
    Array1:<\/strong> Kosten f\u00fcr Produkt A<\/p>\n<\/li>\n
  • \n
    Array2:<\/strong> Kosten f\u00fcr Produkt B<\/p>\n<\/li>\n<\/ul>\n
    In Excel w\u00fcrde die Funktion folgenderma\u00dfen eingesetzt werden:<\/p>\n
    =SUMX2MY2(A2:A5, B2:B5)<\/code><\/pre>\n\n\n\n\n\n\n
    Produkt A<\/th>\nProdukt B<\/th>\n<\/tr>\n
    50<\/td>\n30<\/td>\n<\/tr>\n
    60<\/td>\n20<\/td>\n<\/tr>\n
    40<\/td>\n40<\/td>\n<\/tr>\n
    70<\/td>\n60<\/td>\n<\/tr>\n<\/table>\n
    In Google Tabellen sieht die Formel entsprechend aus:<\/p>\n
    =SUMMEX2MY2(A2:A5, B2:B5)<\/code><\/pre>\n
    Diese Berechnung verdeutlicht die Summe der quadrierten Differenzen und ist hilfreich bei der Planung zuk\u00fcnftiger Budgets.<\/p>\n
    Beispiel 2: Ermittlung der Stabilit\u00e4t von Investitionsrenditen<\/h2>\n
    Ein Analyst m\u00f6chte die Stabilit\u00e4t der Renditen zweier verschiedener Investitionen \u00fcber ein Jahr hinweg durch die Berechnung der Summe der quadrierten Differenzen ihrer monatlichen Renditen vergleichen.<\/p>\n
      \n
    • \n
      Array1:<\/strong> Renditen der Investition 1<\/p>\n<\/li>\n
    • \n
      Array2:<\/strong> Renditen der Investition 2<\/p>\n<\/li>\n<\/ul>\n
      In Excel w\u00fcrde man die Funktion so anwenden:<\/p>\n
      =SUMX2MY2(C2:C13, D2:D13)<\/code><\/pre>\n\n\n\n\n\n\n
      Investition 1<\/th>\nInvestition 2<\/th>\n<\/tr>\n
      5%<\/td>\n4%<\/td>\n<\/tr>\n
      7%<\/td>\n5%<\/td>\n<\/tr>\n
      4%<\/td>\n2%<\/td>\n<\/tr>\n
      7%<\/td>\n7%<\/td>\n<\/tr>\n<\/table>\n
      In Google Tabellen erfolgt die Anwendung analog:<\/p>\n
      =SUMMEX2MY2(C2:C13, D2:D13)<\/code><\/pre>\n
      Dieser Ansatz hilft Investoren zu erkennen, welche Anlage \u00fcber den betrachteten Zeitraum stabilere Renditen erzielt, was entscheidend f\u00fcr das Treffen zuk\u00fcnftiger Investitionsentscheidungen sein kann.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Gibt die Summe der Differenz von Quadraten entsprechender Werte in zwei Matrizen zur\u00fcck<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[324],"tags":[],"class_list":["post-7276","post","type-post","status-publish","format-standard","hentry","category-mathematik-und-trigonometrie"],"acf":[],"yoast_head":"\nSUMX2MY2 (SUMMEX2MY2)-Funktion in Excel: Erkl\u00e4rung, Beispiele und Syntax<\/title>\n<meta name=\"description\" content=\"Kurze Erkl\u00e4rung zur Excel-Funktion SUMX2MY2 (SUMMEX2MY2). Erfahren Sie die Syntax sowie Beispiele zur praktischen Anwendung.\" \/>\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\/de\/sumx2my2\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SUMX2MY2 (SUMMEX2MY2)-Funktion in Excel: Erkl\u00e4rung, Beispiele und Syntax\" \/>\n<meta property=\"og:description\" content=\"Kurze Erkl\u00e4rung zur Excel-Funktion SUMX2MY2 (SUMMEX2MY2). Erfahren Sie die Syntax sowie Beispiele zur praktischen Anwendung.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/de\/sumx2my2\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:11:46+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"SUMX2MY2 (SUMMEX2MY2)-Funktion in Excel: Erkl\u00e4rung, Beispiele und Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/de\/sumx2my2\/\",\"url\":\"https:\/\/functiontranslator.com\/de\/sumx2my2\/\",\"name\":\"SUMX2MY2 (SUMMEX2MY2)-Funktion in Excel: Erkl\u00e4rung, Beispiele und Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:45+00:00\",\"dateModified\":\"2021-02-25T16:11:46+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Kurze Erkl\u00e4rung zur Excel-Funktion SUMX2MY2 (SUMMEX2MY2). Erfahren Sie die Syntax sowie Beispiele zur praktischen Anwendung.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/de\/sumx2my2\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/de\/sumx2my2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/de\/sumx2my2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel-Funktionen\",\"item\":\"https:\/\/functiontranslator.com\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mathematik und Trigonometrie\",\"item\":\"https:\/\/functiontranslator.com\/de\/mathematik-und-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SUMMEX2MY2\"}]},{\"@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\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\/de\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SUMX2MY2 (SUMMEX2MY2)-Funktion in Excel: Erkl\u00e4rung, Beispiele und Syntax","description":"Kurze Erkl\u00e4rung zur Excel-Funktion SUMX2MY2 (SUMMEX2MY2). Erfahren Sie die Syntax sowie Beispiele zur praktischen Anwendung.","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\/de\/sumx2my2\/","og_locale":"de_DE","og_type":"article","og_title":"SUMX2MY2 (SUMMEX2MY2)-Funktion in Excel: Erkl\u00e4rung, Beispiele und Syntax","og_description":"Kurze Erkl\u00e4rung zur Excel-Funktion SUMX2MY2 (SUMMEX2MY2). Erfahren Sie die Syntax sowie Beispiele zur praktischen Anwendung.","og_url":"https:\/\/functiontranslator.com\/de\/sumx2my2\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-25T16:11:46+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"SUMX2MY2 (SUMMEX2MY2)-Funktion in Excel: Erkl\u00e4rung, Beispiele und Syntax","twitter_misc":{"Verfasst von":"glavadmin","Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/de\/sumx2my2\/","url":"https:\/\/functiontranslator.com\/de\/sumx2my2\/","name":"SUMX2MY2 (SUMMEX2MY2)-Funktion in Excel: Erkl\u00e4rung, Beispiele und Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:45+00:00","dateModified":"2021-02-25T16:11:46+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Kurze Erkl\u00e4rung zur Excel-Funktion SUMX2MY2 (SUMMEX2MY2). Erfahren Sie die Syntax sowie Beispiele zur praktischen Anwendung.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/de\/sumx2my2\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/de\/sumx2my2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/de\/sumx2my2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel-Funktionen","item":"https:\/\/functiontranslator.com\/de\/"},{"@type":"ListItem","position":2,"name":"Mathematik und Trigonometrie","item":"https:\/\/functiontranslator.com\/de\/mathematik-und-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"SUMMEX2MY2"}]},{"@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":"de"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/posts\/7276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/comments?post=7276"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/posts\/7276\/revisions"}],"predecessor-version":[{"id":21640,"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/posts\/7276\/revisions\/21640"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/media?parent=7276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/categories?post=7276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/de\/wp-json\/wp\/v2\/tags?post=7276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}