{"id":6787,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/sous-total\/"},"modified":"2021-02-26T08:14:20","modified_gmt":"2021-02-26T08:14:20","slug":"subtotal","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/subtotal\/","title":{"rendered":"SOUS.TOTAL"},"content":{"rendered":"
\n

Introduction \u00e0 SOUS.TOTAL dans Excel et Google Sheets<\/h2>\n

La fonction SOUS.TOTAL est tr\u00e8s utilis\u00e9e tant dans Microsoft Excel que dans Google Sheets pour calculer des sous-totaux sur un ensemble de donn\u00e9es. Cette fonction est particuli\u00e8rement utile lors du filtrage des donn\u00e9es, car elle ne prend en compte que les valeurs visibles.<\/p>\n

Syntaxe et param\u00e8tres<\/h2>\n

Le fonctionnement de cette formule varie l\u00e9g\u00e8rement entre Excel et Google Sheets, mais la syntaxe reste essentiellement la m\u00eame :<\/p>\n

=SOUS.TOTAL(fonction_num, plage1, [plage2], ...)<\/code><\/pre>\n
    \n
  • fonction_num<\/strong> : Un num\u00e9ro qui sp\u00e9cifie la fonction \u00e0 utiliser pour le calcul des sous-totaux. Par exemple, \u00ab\u00a09\u00a0\u00bb pour la somme, \u00ab\u00a01\u00a0\u00bb pour la moyenne, etc.<\/li>\n
  • plage1, [plange2], …<\/strong> : Les plages sur lesquelles effectuer le calcul.<\/li>\n<\/ul>\n
    Exemple basique<\/h2>\n
    Imaginons que nous ayons une liste de ventes par article, comme ci-dessous :<\/p>\n
    A B C Article Ventes Mois Clavier 150 Janvier Souris 80 Janvier Moniteur 170 F\u00e9vrier Clavier 130 Mars <\/code><\/pre>\n
    Pour obtenir le total des ventes visibles apr\u00e8s un filtrage, on pourrait utiliser :<\/p>\n
    =SOUS.TOTAL(9, B2:B5) <\/code><\/pre>\n
    Cette formule donnera la somme de la colonne des ventes, mais uniquement des lignes visibles apr\u00e8s filtrage.<\/p>\n
    Utilisation avanc\u00e9e dans la pratique comptable<\/h2>\n
    Supposons que vous souhaitez calculer le total mensuel des ventes, mais uniquement pour les produits qui surpassent un certain seuil de vente dans leur cat\u00e9gorie. Voici comment on pourrait structurer cela :<\/p>\n
    A B C D Article Cat\u00e9gorie Ventes Mois Clavier \u00c9lectronique 150 Janvier Souris \u00c9lectronique 80 Janvier Moniteur Informatique 170 F\u00e9vrier Clavier \u00c9lectronique 130 Mars <\/code><\/pre>\n
    Pour calculer le total des ventes pour la cat\u00e9gorie \u00ab\u00a0\u00c9lectronique\u00a0\u00bb, mais uniquement pour les mois o\u00f9 les ventes d\u00e9passent 100 $, on pourrait filtrer la colonne des ventes, puis utiliser :<\/p>\n
    =SOUS.TOTAL(9, C2:C5) <\/code><\/pre>\n
    Analyse d’impact des promotions sur les ventes<\/h2>\n
    Une entreprise lance des promotions et souhaite \u00e9valuer leur impact sur les ventes de certains produits. En utilisant un filtrage pour les p\u00e9riodes de promotion et en appliquant SOUS.TOTAL, l\u2019entreprise peut obtenir rapidement un aper\u00e7u des performances :<\/p>\n
    A B C D Article Promo Ventes Mois Clavier Oui 200 Janvier Souris Non 80 Janvier Moniteur Oui 220 F\u00e9vrier Clavier Non 130 Mars <\/code><\/pre>\n
    Calcul du sous-total des ventes uniquement sur les produits en promotion :<\/p>\n
    =SOUS.TOTAL(9, C2:C5) <\/code><\/pre>\n<\/article>\n","protected":false},"excerpt":{"rendered":"
    Renvoie un sous-total dans une liste ou une base de donn\u00e9es<\/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-6787","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SUBTOTAL (SOUS.TOTAL) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SUBTOTAL (SOUS.TOTAL) 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\/subtotal\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SUBTOTAL (SOUS.TOTAL) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SUBTOTAL (SOUS.TOTAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/subtotal\/\" \/>\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:20+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SUBTOTAL (SOUS.TOTAL) 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\/subtotal\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/subtotal\/\",\"name\":\"Fonction SUBTOTAL (SOUS.TOTAL) 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:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SUBTOTAL (SOUS.TOTAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/subtotal\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/subtotal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/subtotal\/#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\":\"SOUS.TOTAL\"}]},{\"@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 SUBTOTAL (SOUS.TOTAL) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SUBTOTAL (SOUS.TOTAL) 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\/subtotal\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SUBTOTAL (SOUS.TOTAL) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SUBTOTAL (SOUS.TOTAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/subtotal\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SUBTOTAL (SOUS.TOTAL) 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\/subtotal\/","url":"https:\/\/functiontranslator.com\/fr\/subtotal\/","name":"Fonction SUBTOTAL (SOUS.TOTAL) 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:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SUBTOTAL (SOUS.TOTAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/subtotal\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/subtotal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/subtotal\/#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":"SOUS.TOTAL"}]},{"@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\/6787","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=6787"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6787\/revisions"}],"predecessor-version":[{"id":29796,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6787\/revisions\/29796"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}