{"id":6793,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/somme-x2my2\/"},"modified":"2021-02-26T08:14:30","modified_gmt":"2021-02-26T08:14:30","slug":"sumx2my2","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/sumx2my2\/","title":{"rendered":"SOMME.X2MY2"},"content":{"rendered":"

Description de la Fonction<\/h2>\n

La fonction SOMME.X2MY2<\/strong> dans Microsoft Excel et Google Sheets est une fonction utile pour effectuer des op\u00e9rations math\u00e9matiques complexes. Elle prend en entr\u00e9e deux plages de valeurs, appel\u00e9es matrice_x<\/em> et matrice_y<\/em>, et calcule la somme des diff\u00e9rences des carr\u00e9s des valeurs correspondantes dans ces plages. Concr\u00e8tement, si A et B sont deux ensembles de nombres, la fonction effectue le calcul suivant : (A1<\/sub>2<\/sup> – B1<\/sub>2<\/sup>) + (A2<\/sub>2<\/sup> – B2<\/sub>2<\/sup>) + … + (An<\/sub>2<\/sup> – Bn<\/sub>2<\/sup>).<\/p>\n

Syntaxe<\/h2>\n

La syntaxe de la fonction est :<\/p>\n

=SOMME.X2MY2(matrice_x, matrice_y)<\/code><\/pre>\n
    \n
  • matrice_x<\/strong> : La premi\u00e8re plage de cellules ou un tableau de nombres.<\/li>\n
  • matrice_y<\/strong> : La seconde plage de cellules ou un tableau de nombres.<\/li>\n<\/ul>\n
    Les plages matrice_x<\/em> et matrice_y<\/em> doivent comporter le m\u00eame nombre d’\u00e9l\u00e9ments. Si ce n’est pas le cas, la fonction g\u00e9n\u00e8re une erreur.<\/p>\n
    Exemples d’Utilisation<\/h2>\n\n\n\n\n\n\n\n\n
    Cellule<\/th>\nValeur<\/th>\n<\/tr>\n
    A1<\/td>\n3<\/td>\n<\/tr>\n
    A2<\/td>\n4<\/td>\n<\/tr>\n
    A3<\/td>\n5<\/td>\n<\/tr>\n
    B1<\/td>\n1<\/td>\n<\/tr>\n
    B2<\/td>\n2<\/td>\n<\/tr>\n
    B3<\/td>\n3<\/td>\n<\/tr>\n<\/table>\n
    Formule : =SOMME.X2MY2(A1:A3, B1:B3)<\/code><\/p>\n
    R\u00e9sultat : 35<\/p>\n
    Explication : Calcule (3\u00b2 – 1\u00b2) + (4\u00b2 – 2\u00b2) + (5\u00b2 – 3\u00b2) = (9 – 1) + (16 – 4) + (25 – 9) = 35<\/p>\n
    Sc\u00e9narios Pratiques<\/h2>\n
    Analyse du rendement d’une part de march\u00e9<\/h2>\n
    Supposons que vous ayez les rendements r\u00e9els d’un actif sur trois jours dans une colonne et les rendements moyens du march\u00e9 pour les m\u00eames jours dans une autre colonne. Utilisez cette fonction pour \u00e9valuer la variabilit\u00e9 des rendements de l’actif par rapport au rendement moyen du march\u00e9 :<\/p>\n
    =SOMME.X2MY2(C2:C4, D2:D4)<\/code><\/pre>\n
    Cette formule d\u00e9termine la somme des diff\u00e9rences des carr\u00e9s des rendements, ce qui peut aider \u00e0 analyser la volatilit\u00e9 de l\u2019actif compar\u00e9e \u00e0 la moyenne du march\u00e9.<\/p>\n
    Calcul des \u00e9carts \u00e9nerg\u00e9tiques<\/h2>\n
    Pendant un audit \u00e9nerg\u00e9tique, si vous avez mesur\u00e9 la consommation d’\u00e9nergie pr\u00e9vue dans une colonne et la consommation r\u00e9elle dans une autre colonne pour diff\u00e9rents appareils, utilisez cette fonction pour \u00e9valuer l’\u00e9cart total d\u2019\u00e9nergie :<\/p>\n
    =SOMME.X2MY2(E2:E5, F2:F5)<\/code><\/pre>\n
    Cette formulation vous permettra de quantifier l’\u00e9cart \u00e9nerg\u00e9tique en se basant sur la diff\u00e9rence des carr\u00e9s des valeurs pr\u00e9vues et r\u00e9elles, offrant ainsi une mesure pr\u00e9cise surtout pour les grands \u00e9carts.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la somme de la diff\u00e9Rence des caRR\u00e9s des valeuRs coRRespondantes de deux matRices<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[310],"tags":[],"class_list":["post-6793","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SUMX2MY2 (SOMME.X2MY2) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SUMX2MY2 (SOMME.X2MY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/sumx2my2\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SUMX2MY2 (SOMME.X2MY2) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SUMX2MY2 (SOMME.X2MY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/sumx2my2\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:14:30+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SUMX2MY2 (SOMME.X2MY2) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumx2my2\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sumx2my2\/\",\"name\":\"Fonction SUMX2MY2 (SOMME.X2MY2) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:14:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SUMX2MY2 (SOMME.X2MY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumx2my2\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sumx2my2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumx2my2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math\u00e9matiques et trigonom\u00e9trie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SOMME.X2MY2\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction SUMX2MY2 (SOMME.X2MY2) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SUMX2MY2 (SOMME.X2MY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/sumx2my2\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SUMX2MY2 (SOMME.X2MY2) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SUMX2MY2 (SOMME.X2MY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sumx2my2\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SUMX2MY2 (SOMME.X2MY2) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/sumx2my2\/","url":"https:\/\/functiontranslator.com\/fr\/sumx2my2\/","name":"Fonction SUMX2MY2 (SOMME.X2MY2) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:14:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SUMX2MY2 (SOMME.X2MY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sumx2my2\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sumx2my2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sumx2my2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Math\u00e9matiques et trigonom\u00e9trie","item":"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"SOMME.X2MY2"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6793"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6793\/revisions"}],"predecessor-version":[{"id":29802,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6793\/revisions\/29802"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}