{"id":6513,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bdsomme\/"},"modified":"2021-02-26T08:05:15","modified_gmt":"2021-02-26T08:05:15","slug":"dsum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dsum\/","title":{"rendered":"BDSOMME"},"content":{"rendered":"

Description et Syntaxe<\/h2>\n

La fonction DSUM<\/strong> (BDSOMME en fran\u00e7ais) dans Microsoft Excel et Google Sheets est utilis\u00e9e pour calculer la somme des valeurs dans une plage donn\u00e9e, en fonction des crit\u00e8res sp\u00e9cifi\u00e9s. Cette fonction est id\u00e9ale pour les analyses d\u00e9taill\u00e9es de donn\u00e9es organis\u00e9es en listes ou en tableaux.<\/p>\n

Syntaxe g\u00e9n\u00e9rale :<\/p>\n

=DSUM(base_donn\u00e9es; champ; crit\u00e8res)<\/code><\/pre>\n
    \n
  • base_donn\u00e9es<\/strong> : La plage de cellules qui constitue la base de donn\u00e9es.<\/li>\n
  • champ<\/strong> : Le nom de la colonne dans laquelle se trouvent les valeurs \u00e0 additionner. Il doit \u00eatre indiqu\u00e9 entre guillemets ou correspondre au num\u00e9ro de la colonne.<\/li>\n
  • crit\u00e8res<\/strong> : La plage de cellules d\u00e9finissant les conditions \u00e0 remplir.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    Consid\u00e9rons une base de donn\u00e9es avec les champs suivants : Id, Nom, Ventes, et R\u00e9gion. Pour calculer la somme des ventes dans la r\u00e9gion \"Est\", votre formule sera :=DSUM(A1:D20, \"Ventes\", G1:G2)<\/code> o\u00f9 A1:D20 repr\u00e9sente la plage compl\u00e8te des donn\u00e9es, \"Ventes\" indique la colonne des valeurs \u00e0 sommer et G1:G2 sp\u00e9cifie les crit\u00e8res de filtrage.<\/pre>\n
    Exemples Pratiques<\/h2>\n
    Cas d’usage 1: Somme des ventes par produit<\/h2>\n
    Imaginez que vous analysez les donn\u00e9es de ventes d’une entreprise pour un produit sp\u00e9cifique sur une p\u00e9riode d\u00e9termin\u00e9e.<\/p>\n
    =DSUM(A1:D100, \"Ventes\", J1:J3)<\/code><\/pre>\n
    Description de la solution :<\/strong> Ici, A1:D100 repr\u00e9sente l’int\u00e9gralit\u00e9 des donn\u00e9es de vente, \u00ab\u00a0Ventes\u00a0\u00bb est la colonne o\u00f9 les valeurs sont totalis\u00e9es, et J1:J3 d\u00e9finit le produit et la p\u00e9riode cibl\u00e9e.<\/p>\n
    Cas d’usage 2: \u00c9valuation des d\u00e9penses par d\u00e9partement<\/h2>\n
    Supposez que vous \u00eates charg\u00e9 de rapporter les d\u00e9penses par d\u00e9partement dans votre entreprise sur une base mensuelle.<\/p>\n
    =DSUM(A1:E500, \"D\u00e9penses\", H1:H2)<\/code><\/pre>\n
    Description de la solution :<\/strong> A1:E500 correspond \u00e0 votre plage de donn\u00e9es totale, \u00ab\u00a0D\u00e9penses\u00a0\u00bb \u00e0 la colonne des co\u00fbts \u00e0 additionner, et H1:H2 d\u00e9limite le d\u00e9partement et le mois pour l’\u00e9valuation des d\u00e9penses.<\/p>\n
    Conclusion<\/h2>\n
    Ces exemples illustrent la puissance de la fonction DSUM pour approfondir l’analyse des donn\u00e9es. En appliquant des crit\u00e8res judicieusement choisis, cette fonction permet d’obtenir des r\u00e9sultats pr\u00e9cis pour des groupements sp\u00e9cifiques de donn\u00e9es, facilitant ainsi la prise de d\u00e9cision et l’analyse sectorielle.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Ajoute les nombres dAns lA colonne de chAmp des enregistrements de lA bAse de donn\u00e9es, qui r\u00e9pondent Aux crit\u00e8res<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[322],"tags":[],"class_list":["post-6513","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"\nFonction DSUM (BDSOMME) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DSUM (BDSOMME) 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\/dsum\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DSUM (BDSOMME) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DSUM (BDSOMME) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dsum\/\" \/>\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:05:15+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DSUM (BDSOMME) 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\/dsum\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dsum\/\",\"name\":\"Fonction DSUM (BDSOMME) 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:05:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DSUM (BDSOMME) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dsum\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dsum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dsum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de donn\u00e9es\",\"item\":\"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BDSOMME\"}]},{\"@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 DSUM (BDSOMME) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DSUM (BDSOMME) 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\/dsum\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DSUM (BDSOMME) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DSUM (BDSOMME) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dsum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DSUM (BDSOMME) 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\/dsum\/","url":"https:\/\/functiontranslator.com\/fr\/dsum\/","name":"Fonction DSUM (BDSOMME) 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:05:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DSUM (BDSOMME) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dsum\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dsum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dsum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Base de donn\u00e9es","item":"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/"},{"@type":"ListItem","position":3,"name":"BDSOMME"}]},{"@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\/6513","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=6513"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6513\/revisions"}],"predecessor-version":[{"id":29525,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6513\/revisions\/29525"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}