{"id":6493,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bdnb\/"},"modified":"2021-02-26T08:04:33","modified_gmt":"2021-02-26T08:04:33","slug":"dcount","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dcount\/","title":{"rendered":"BDNB"},"content":{"rendered":"

La fonction DCOUNT, appel\u00e9e BDNB en fran\u00e7ais, est extr\u00eamement utile dans Excel et Google Sheets pour compter les cellules d’une colonne de base de donn\u00e9es qui satisfont \u00e0 des conditions d\u00e9finies. Cet article donne une vue d\u00e9taill\u00e9e de son fonctionnement, de sa syntaxe et propose des exemples concrets d’utilisation.<\/p>\n

Explication du fonctionnement<\/h2>\n

La fonction BDNB<\/strong> permet de compter les entr\u00e9es dans une colonne de base de donn\u00e9es qui correspondent \u00e0 des crit\u00e8res d\u00e9termin\u00e9s \u00e0 l’avance. Elle est particuli\u00e8rement utile pour des analyses n\u00e9cessitant un filtrage pr\u00e9alable.<\/p>\n

Syntaxe<\/h2>\n
BDNB(base_de_donn\u00e9es; champ; crit\u00e8res)<\/code><\/pre>\n
    \n
  • base_de_donn\u00e9es<\/strong> : Ensemble des cellules qui contiennent vos donn\u00e9es, incluant les en-t\u00eates de colonnes.<\/li>\n
  • champ<\/strong> : Colonne \u00e0 compter, pouvant \u00eatre sp\u00e9cifi\u00e9e par le nom de l’en-t\u00eate (entre guillemets) ou par le num\u00e9ro de la colonne.<\/li>\n
  • crit\u00e8res<\/strong> : Plage de cellules qui d\u00e9finit les conditions sp\u00e9cifiques \u00e0 appliquer. Cette plage doit inclure au moins une ligne pour les en-t\u00eates de colonnes et une pour les conditions relatives \u00e0 ces colonnes.<\/li>\n<\/ul>\n
    Exemple d’application<\/h2>\n
    Supposons que vous disposez d’une base de donn\u00e9es d’employ\u00e9s comme suit :<\/p>\n\n\n\n\n\n\n\n
    ID<\/th>\nNom<\/th>\nD\u00e9partement<\/th>\n\u00c2ge<\/th>\n<\/tr>\n
    1<\/td>\nLisa<\/td>\nComptabilit\u00e9<\/td>\n28<\/td>\n<\/tr>\n
    2<\/td>\nMarc<\/td>\nMarketing<\/td>\n34<\/td>\n<\/tr>\n
    3<\/td>\nJulia<\/td>\nComptabilit\u00e9<\/td>\n22<\/td>\n<\/tr>\n
    4<\/td>\nJean<\/td>\nIT<\/td>\n29<\/td>\n<\/tr>\n
    5<\/td>\nClaire<\/td>\nMarketing<\/td>\n36<\/td>\n<\/tr>\n<\/table>\n
    Pour compter le nombre d’employ\u00e9s dans le d\u00e9partement de Marketing, votre formule serait :<\/p>\n
    =BDNB(A1:D6; \"\u00c2ge\"; A9:B10)<\/code><\/pre>\n
    o\u00f9 \u00ab\u00a0A1:D6\u00a0\u00bb est la plage de la base de donn\u00e9es, \u00ab\u00a0\u00c2ge\u00a0\u00bb est le champ s\u00e9lectionn\u00e9 pour le comptage (nous avons besoin d’un compte), et \u00ab\u00a0A9:B10\u00a0\u00bb contiendrait :<\/p>\n\n\n\n
    D\u00e9partement<\/th>\n<\/tr>\n
    Marketing<\/td>\n<\/tr>\n<\/table>\n
    Cas pratiques d’utilisation<\/h2>\n
    Analyse d\u00e9mographique<\/h2>\n
    Pour une analyse d\u00e9mographique des employ\u00e9s par d\u00e9partement, BDNB peut rapidement compter le nombre d’employ\u00e9s r\u00e9partis par \u00e2ge et par secteur.<\/p>\n
    Suivi de projet<\/h2>\n
    Dans le cadre de la gestion de projet, si une entreprise souhaite d\u00e9terminer le nombre de projets actifs par segment de march\u00e9, l’utilisation de BDNB peut aider \u00e0 compter ces projets selon des crit\u00e8res d\u00e9finis, facilitant ainsi l’allocation optimale des ressources.<\/p>\n
    En conclusion, cette fonction est essentielle pour r\u00e9aliser des analyses d\u00e9taill\u00e9es de larges bases de donn\u00e9es, permettant des d\u00e9comptes conditionnels rapides et pr\u00e9cis.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Compte le nombre de Cellules d\u2019une base de donn\u00e9es qui Contiennent des nombres<\/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-6493","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"\nFonction DCOUNT (BDNB) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DCOUNT (BDNB) 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\/dcount\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DCOUNT (BDNB) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DCOUNT (BDNB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dcount\/\" \/>\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:04: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 DCOUNT (BDNB) 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\/dcount\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dcount\/\",\"name\":\"Fonction DCOUNT (BDNB) 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:04:33+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DCOUNT (BDNB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dcount\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dcount\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dcount\/#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\":\"BDNB\"}]},{\"@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 DCOUNT (BDNB) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DCOUNT (BDNB) 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\/dcount\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DCOUNT (BDNB) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DCOUNT (BDNB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dcount\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:33+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DCOUNT (BDNB) 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\/dcount\/","url":"https:\/\/functiontranslator.com\/fr\/dcount\/","name":"Fonction DCOUNT (BDNB) 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:04:33+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DCOUNT (BDNB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dcount\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dcount\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dcount\/#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":"BDNB"}]},{"@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\/6493","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=6493"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6493\/revisions"}],"predecessor-version":[{"id":29505,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6493\/revisions\/29505"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}