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

Introduction \u00e0 SOMME.X2PY2<\/h2>\n

La fonction SOMME.X2PY2 dans Excel permet de calculer la somme des produits des carr\u00e9s des \u00e9l\u00e9ments correspondants de deux plages de donn\u00e9es sp\u00e9cifi\u00e9es. Cette fonction est particuli\u00e8rement utile pour les analyses statistiques, y compris lorsqu’il s’agit de calculer la somme des produits des termes \u00e9lev\u00e9s au carr\u00e9.<\/p>\n

Syntaxe et Utilisation<\/h2>\n

La syntaxe de la fonction SOMME.X2PY2 est la suivante :<\/p>\n

=SOMME.X2PY2(matrice1, matrice2)<\/code><\/pre>\n
    \n
  • matrice1<\/code> : La premi\u00e8re plage de cellules ou matrice.<\/li>\n
  • matrice2<\/code> : La deuxi\u00e8me plage de cellules ou matrice.<\/li>\n<\/ul>\n
    Il est essentiel que les plages matrice1<\/code> et matrice2<\/code> contiennent le m\u00eame nombre de cellules, faute de quoi Excel affichera un message d’erreur.<\/p>\n
    Exemple :<\/p>\n
    =SOMME.X2PY2(A1:A3, B1:B3)<\/code><\/pre>\n
    Dans cet exemple, si A1:A3 contient les valeurs 1, 2, 3 et B1:B3 contient les valeurs 4, 5, 6, la fonction renverra :<\/p>\n
    1^2*4^2 + 2^2*5^2 + 3^2*6^2 = 16 + 100 + 324 = 440<\/p>\n
    Exemples Pratiques<\/h2>\n
    Calcul des sommes des carr\u00e9s dans l’analyse de r\u00e9gression<\/h3>\n
    Supposons que vous effectuez une analyse de r\u00e9gression et que vous avez besoin de calculer la somme des carr\u00e9s des produits des valeurs X et Y pour l’int\u00e9grer \u00e0 votre \u00e9quation de r\u00e9gression.<\/p>\n\n\n\n\n\n
    Valeurs X<\/th>\nValeurs Y<\/th>\n<\/tr>\n
    1<\/td>\n2<\/td>\n<\/tr>\n
    3<\/td>\n1<\/td>\n<\/tr>\n
    5<\/td>\n6<\/td>\n<\/tr>\n<\/table>\n
    Formule :<\/p>\n
    =SOMME.X2PY2(A1:A3, B1:B3)<\/code><\/pre>\n
    Cette formule calculera la somme des produits des carr\u00e9s des valeurs X et Y list\u00e9es dans les colonnes A et B.<\/p>\n
    Application en finances<\/h3>\n
    Imaginez que vous \u00eates un analyste financier examinant la relation entre le risque de deux portefeuilles d’investissement. Les fluctuations journali\u00e8res des deux portefeuilles sont enregistr\u00e9es dans deux colonnes distinctes.<\/p>\n\n\n\n\n\n
    Fluctuation Portefeuille 1<\/th>\nFluctuation Portefeuille 2<\/th>\n<\/tr>\n
    0.5%<\/td>\n0.8%<\/td>\n<\/tr>\n
    1.2%<\/td>\n0.9%<\/td>\n<\/tr>\n
    1.5%<\/td>\n0.4%<\/td>\n<\/tr>\n<\/table>\n
    Formule :<\/p>\n
    =SOMME.X2PY2(A1:A3, B1:B3)<\/code><\/pre>\n
    Cette formule donnera la somme des produits des carr\u00e9s des fluctuations journali\u00e8res, ce qui peut fournir un aper\u00e7u de la corr\u00e9lation entre les performances des deux portefeuilles.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la somme de la somme 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-6794","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SUMX2PY2 (SOMME.X2PY2) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SUMX2PY2 (SOMME.X2PY2) 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\/sumx2py2\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SUMX2PY2 (SOMME.X2PY2) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SUMX2PY2 (SOMME.X2PY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/sumx2py2\/\" \/>\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:33+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SUMX2PY2 (SOMME.X2PY2) 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\/sumx2py2\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sumx2py2\/\",\"name\":\"Fonction SUMX2PY2 (SOMME.X2PY2) 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:33+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SUMX2PY2 (SOMME.X2PY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumx2py2\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sumx2py2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumx2py2\/#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.X2PY2\"}]},{\"@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 SUMX2PY2 (SOMME.X2PY2) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SUMX2PY2 (SOMME.X2PY2) 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\/sumx2py2\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SUMX2PY2 (SOMME.X2PY2) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SUMX2PY2 (SOMME.X2PY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sumx2py2\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:33+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SUMX2PY2 (SOMME.X2PY2) 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\/sumx2py2\/","url":"https:\/\/functiontranslator.com\/fr\/sumx2py2\/","name":"Fonction SUMX2PY2 (SOMME.X2PY2) 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:33+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SUMX2PY2 (SOMME.X2PY2) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sumx2py2\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sumx2py2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sumx2py2\/#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.X2PY2"}]},{"@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\/6794","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=6794"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6794\/revisions"}],"predecessor-version":[{"id":29803,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6794\/revisions\/29803"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}