{"id":6791,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/sommeprod\/"},"modified":"2021-02-26T08:14:27","modified_gmt":"2021-02-26T08:14:27","slug":"sumproduct","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/sumproduct\/","title":{"rendered":"SOMMEPROD"},"content":{"rendered":"

Description et Syntaxe de SOMMEPROD<\/h2>\n

SOMMEPROD<\/strong> est une fonction avanc\u00e9e \u00e0 la fois dans Excel et Google Sheets, permettant de calculer la somme des produits entre des tableaux ou des plages de donn\u00e9es correspondants. Elle simplifie les calculs complexes qui n\u00e9cessitent des multiplications suivies d’une addition, en les r\u00e9alisant en une seule \u00e9tape. <\/p>\n

Syntaxe de SOMMEPROD dans Excel et Google Sheets :<\/strong> <\/p>\n

=SOMMEPROD(matrice1, [matrice2], ...)<\/code><\/pre>\n
    \n
  • matrice1, matrice2, …<\/strong> : Repr\u00e9sentent les matrices ou plages de donn\u00e9es. Il est imp\u00e9ratif que chaque matrice ait un nombre identique d\u2019\u00e9l\u00e9ments. Si ce n’est pas le cas, la fonction renverra une erreur.<\/li>\n<\/ul>\n
     Exemple: <\/p>\n
    =SOMMEPROD(A1:A3, B1:B3)<\/code><\/pre>\n
     Cette formule effectue le calcul suivant: (A1*B1 + A2*B2 + A3*B3). <\/p>\n
    Sc\u00e9narios d’utilisation en contexte r\u00e9el<\/h2>\n
    Pour mieux saisir l\u2019utilit\u00e9 de SOMMEPROD<\/strong>, explorons quelques sc\u00e9narios courants o\u00f9 elle s\u2019av\u00e8re particuli\u00e8rement efficace.<\/p>\n
    Calcul du chiffre d’affaires total<\/h2>\n
     Supposons que vous disposez d\u2019une liste comprenant des quantit\u00e9s de produits vendus et leurs prix unitaires. SOMMEPROD<\/strong> permet de calculer rapidement le chiffre d’affaires total. <\/p>\n\n\n\n\n\n
    Produit<\/th>\nQuantit\u00e9 (A)<\/th>\nPrix Unit. (B)<\/th>\n<\/tr>\n
    Pommes<\/td>\n30<\/td>\n0.50<\/td>\n<\/tr>\n
    Oranges<\/td>\n20<\/td>\n0.60<\/td>\n<\/tr>\n
    Bananes<\/td>\n45<\/td>\n0.40<\/td>\n<\/tr>\n<\/table>\n
     La formule appropri\u00e9e serait : <\/p>\n
    =SOMMEPROD(B2:B4, C2:C4)<\/code><\/pre>\n
     Cette formule multiplie chaque quantit\u00e9 par son prix unitaire correspondant et somme ensuite tous les produits pour donner le revenu total. <\/p>\n
    \u00c9valuation du poids total d’un envoi<\/h2>\n
     Une entreprise qui souhaite estimer le poids total des produits exp\u00e9di\u00e9s selon le nombre d’articles par colis et leur poids unitaire trouvera \u00e9galement SOMMEPROD tr\u00e8s utile. <\/p>\n\n\n\n\n\n
    Article<\/th>\nNombre d’articles (X)<\/th>\nPoids par article (Y)<\/th>\n<\/tr>\n
    Chaise<\/td>\n50<\/td>\n5<\/td>\n<\/tr>\n
    Table<\/td>\n20<\/td>\n15<\/td>\n<\/tr>\n
    Lampe<\/td>\n60<\/td>\n1<\/td>\n<\/tr>\n<\/table>\n
     Formulaire de calcul du poids total : <\/p>\n
    =SOMMEPROD(X2:X4, Y2:Y4)<\/code><\/pre>\n
     Ce calcul multiplie le nombre d’articles par leur poids respectif puis additionne les r\u00e9sultats pour obtenir le poids total. <\/p>\n
     Cette documentation vous aide \u00e0 comprendre comment exploiter la fonction SOMMEPROD d’Excel et Google Sheets dans des situations concr\u00e8tes avec des exemples pr\u00e9cis.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Multiplie les valeurs correspondantes des Matrices sp\u00e9cifi\u00e9es et calcule la soMMe de ces produits<\/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-6791","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SUMPRODUCT (SOMMEPROD) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SUMPRODUCT (SOMMEPROD) 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\/sumproduct\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SUMPRODUCT (SOMMEPROD) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SUMPRODUCT (SOMMEPROD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/sumproduct\/\" \/>\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:27+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SUMPRODUCT (SOMMEPROD) 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\/sumproduct\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sumproduct\/\",\"name\":\"Fonction SUMPRODUCT (SOMMEPROD) 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:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SUMPRODUCT (SOMMEPROD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumproduct\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sumproduct\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumproduct\/#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\":\"SOMMEPROD\"}]},{\"@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 SUMPRODUCT (SOMMEPROD) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SUMPRODUCT (SOMMEPROD) 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\/sumproduct\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SUMPRODUCT (SOMMEPROD) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SUMPRODUCT (SOMMEPROD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sumproduct\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SUMPRODUCT (SOMMEPROD) 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\/sumproduct\/","url":"https:\/\/functiontranslator.com\/fr\/sumproduct\/","name":"Fonction SUMPRODUCT (SOMMEPROD) 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:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SUMPRODUCT (SOMMEPROD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sumproduct\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sumproduct\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sumproduct\/#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":"SOMMEPROD"}]},{"@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\/6791","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=6791"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6791\/revisions"}],"predecessor-version":[{"id":29800,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6791\/revisions\/29800"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}