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

Cet article d\u00e9taille l’utilisation de la fonction SOMME.SI<\/strong> dans Microsoft Excel et Google Sheets, \u00e9galement connue sous le nom de SUMIF<\/strong> en anglais. Cette fonction est indispensable pour r\u00e9aliser des sommes conditionnelles dans vos feuilles de calcul.<\/p>\n

Description de la fonction et syntaxe<\/h2>\n

La fonction SOMME.SI<\/strong> permet d’additionner les valeurs d’une plage qui r\u00e9pondent \u00e0 un crit\u00e8re sp\u00e9cifique. Voici comment elle se pr\u00e9sente :<\/p>\n

=SOMME.SI(plage; crit\u00e8re; [plage_somme])<\/code><\/pre>\n
    \n
  • plage<\/strong> : La plage de cellules o\u00f9 le crit\u00e8re est \u00e9valu\u00e9.<\/li>\n
  • crit\u00e8re<\/strong> : Le crit\u00e8re qui d\u00e9termine les cellules \u00e0 sommer. Il peut s’agir d’une expression comme \u00ab\u00a0>=10\u00a0\u00bb ou d’une valeur exacte telle que \u00ab\u00a0Valid\u00e9\u00a0\u00bb.<\/li>\n
  • plage_somme<\/strong> (optionnelle) : La plage contenant les valeurs \u00e0 additionner. Si non sp\u00e9cifi\u00e9e, les valeurs dans la \u00ab\u00a0plage\u00a0\u00bb sp\u00e9cifi\u00e9e sont additionn\u00e9es.<\/li>\n<\/ul>\n
    Exemple simple :<\/p>\n
    =SOMME.SI(A2:A10; \">20\"; B2:B10)<\/code><\/pre>\n
    Cette formule additionne les valeurs dans la plage B2:B10 lorsque les cellules correspondantes dans A2:A10 ont des valeurs sup\u00e9rieures \u00e0 20.<\/p>\n
    Applications pratiques de SOMME.SI<\/h2>\n
    Voici deux cas d’utilisation fr\u00e9quents de SOMME.SI dans Excel ou Google Sheets.<\/p>\n
    Exemple 1: Gestion d’un budget<\/h2>\n
    Si vous disposez d’une liste de d\u00e9penses classifi\u00e9es et souhaitez calculer le total des d\u00e9penses de nourriture, consid\u00e9rez le tableau suivant :<\/p>\n\n\n\n\n\n
    Cat\u00e9gorie<\/th>\nD\u00e9pense<\/th>\n<\/tr>\n
    Alimentation<\/td>\n120<\/td>\n<\/tr>\n
    V\u00eatements<\/td>\n50<\/td>\n<\/tr>\n
    Alimentation<\/td>\n80<\/td>\n<\/tr>\n<\/table>\n
    La formule pour obtenir la somme des d\u00e9penses alimentaires est :<\/p>\n
    =SOMME.SI(A2:A4; \"Alimentation\"; B2:B4)<\/code><\/pre>\n
    Cela donne 200, r\u00e9sultant de la somme de 120 et 80.<\/p>\n
    Exemple 2: Analyse de ventes<\/h2>\n
    Supposez que vous \u00eates responsable des ventes et souhaitez conna\u00eetre le montant total des articles vendus pour au moins 100 \u20ac. Prenons l’exemple suivant :<\/p>\n\n\n\n\n\n
    Article<\/th>\nPrix<\/th>\n<\/tr>\n
    Produit A<\/td>\n95<\/td>\n<\/tr>\n
    Produit B<\/td>\n110<\/td>\n<\/tr>\n
    Produit C<\/td>\n70<\/td>\n<\/tr>\n<\/table>\n
    La formule pour calculer le total des ventes \u00e9gales ou sup\u00e9rieures \u00e0 100 \u20ac serait :<\/p>\n
    =SOMME.SI(B2:B4; \">=100\")<\/code><\/pre>\n
    Ici, le montant retourn\u00e9 est 110, correspondant aux ventes du Produit B qui satisfait le crit\u00e8re.<\/p>\n
    Conclusion :<\/strong> La fonction SOMME.SI<\/strong> s’av\u00e8re extr\u00eamement utile pour les analyses financi\u00e8res, la gestion des donn\u00e9es de ventes, ou toute situation n\u00e9cessitant des additions conditionnelles. Elle aide \u00e0 optimiser le temps et l’efficacit\u00e9 lors de l’analyse de volumes importants de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Additionne les cellules sp\u00e9cifi\u00e9es si elles r\u00e9pondent \u00e0 un crit\u00e8re donn\u00e9<\/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-6789","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SUMIF (SOMME.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SUMIF (SOMME.SI) 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\/sumif\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SUMIF (SOMME.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SUMIF (SOMME.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/sumif\/\" \/>\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:23+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SUMIF (SOMME.SI) 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\/sumif\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sumif\/\",\"name\":\"Fonction SUMIF (SOMME.SI) 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:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SUMIF (SOMME.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumif\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sumif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumif\/#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.SI\"}]},{\"@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 SUMIF (SOMME.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SUMIF (SOMME.SI) 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\/sumif\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SUMIF (SOMME.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SUMIF (SOMME.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sumif\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SUMIF (SOMME.SI) 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\/sumif\/","url":"https:\/\/functiontranslator.com\/fr\/sumif\/","name":"Fonction SUMIF (SOMME.SI) 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:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SUMIF (SOMME.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sumif\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sumif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sumif\/#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.SI"}]},{"@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\/6789","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=6789"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6789\/revisions"}],"predecessor-version":[{"id":29798,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6789\/revisions\/29798"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}