{"id":6494,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bdnbval\/"},"modified":"2021-02-26T08:04:35","modified_gmt":"2021-02-26T08:04:35","slug":"dcounta","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dcounta\/","title":{"rendered":"BDNBVAL"},"content":{"rendered":"

La fonction DCOUNTA, d\u00e9sign\u00e9e BDNBVAL dans la version fran\u00e7aise de Microsoft Excel, permet de compter le nombre de cellules non vides dans une colonne sp\u00e9cifique d\u2019une base de donn\u00e9es qui satisfont \u00e0 des crit\u00e8res d\u00e9finis. Cette fonction est particuli\u00e8rement pr\u00e9cieuse pour analyser de grands ensembles de donn\u00e9es. Son \u00e9quivalent dans les versions anglaises d\u2019Excel et de Google Sheets est \u00e9galement nomm\u00e9 DCOUNTA.<\/p>\n

Syntaxe et Utilisation<\/h2>\n

La syntaxe de la fonction DCOUNTA est la suivante :<\/p>\n

DCOUNTA(base_de_donn\u00e9es, champ, crit\u00e8res)<\/code><\/pre>\n
    \n
  • base_de_donn\u00e9es<\/b> : D\u00e9signe la plage de cellules qui constitue votre base de donn\u00e9es.<\/li>\n
  • champ<\/b> : Sp\u00e9cifie la colonne \u00e0 analyser, indiqu\u00e9e soit par le nom de son en-t\u00eate (entre guillemets) soit par le num\u00e9ro de la colonne.<\/li>\n
  • crit\u00e8res<\/b> : Correspond \u00e0 la plage de cellules contenant les conditions sp\u00e9cifiques qui filtrent les lignes \u00e0 prendre en compte pour le comptage.<\/li>\n<\/ul>\n
    Exemple Pratique<\/h2>\n
    Supposons une base de donn\u00e9es d\u2019employ\u00e9s avec les colonnes suivantes : ID, Nom, D\u00e9partement, et Salaire. Pour montrer comment utiliser DCOUNTA, imaginons que nous souhaitions compter le nombre d\u2019employ\u00e9s du d\u00e9partement des ventes. D\u00e9partement = \u00ab\u00a0Ventes\u00a0\u00bb.<\/p>\n
    Base de donn\u00e9es: A B C D 1 ID Nom D\u00e9partement Salaire 2 001 Dupont Ventes 45000 3 002 Durant RH 42000 4 003 L\u00e9on Ventes 48000 5 004 Petit IT 50000 Crit\u00e8res: G H 1 D\u00e9partement 2 Ventes<\/code><\/pre>\n
    La fonction s’appliquerait ainsi :<\/p>\n
    =DCOUNTA(A1:D5, \"D\u00e9partement\", G1:H2)<\/code><\/pre>\n
    Cette formule renvoie le nombre 2, indiquant qu\u2019il y a deux employ\u00e9s dans le d\u00e9partement des ventes.<\/p>\n
    Cas d’Utilisation<\/h2>\n
    1. Compter le nombre d’employ\u00e9s avec un salaire sp\u00e9cifique ou sup\u00e9rieur :<\/b><\/p>\n
    Pour cette t\u00e2che, nous pourrions \u00e9tablir un crit\u00e8re de salaire minimum et utiliser DCOUNTA pour compter les employ\u00e9s qui r\u00e9pondent \u00e0 cette condition.<\/p>\n
    Crit\u00e8res: G H 1 Salaire 2 >=45000 Formule: =DCOUNTA(A1:D5, \"Salaire\", G1:H2)<\/code><\/pre>\n
    Cette formule d\u00e9compte tous les employ\u00e9s avec un salaire d\u2019au moins 45000.<\/p>\n
    2. Compter le nombre d\u2019employ\u00e9s dans plusieurs d\u00e9partements :<\/b><\/p>\n
    Si l\u2019on veut conna\u00eetre le nombre d\u2019employ\u00e9s travaillant \u00e0 la fois dans les d\u00e9partements de Ventes et IT, la formule serait :<\/p>\n
    Crit\u00e8res: G H 1 D\u00e9partement 2 Ventes 3 IT Formule: =DCOUNTA(A1:D5, \"D\u00e9partement\", G1:H3)<\/code><\/pre>\n
    Cette formule d\u00e9termine le total des employ\u00e9s travaillant dans les d\u00e9partements des Ventes et de IT.<\/p>\n
    En ma\u00eetrisant la fonction DCOUNTA, vous pouvez extraire des statistiques pertinentes pour une gestion et une analyse de donn\u00e9es efficaces et \u00e9clair\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Compte les Cellules non vides d\u2019une 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":[322],"tags":[],"class_list":["post-6494","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"\nFonction DCOUNTA (BDNBVAL) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DCOUNTA (BDNBVAL) 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\/dcounta\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DCOUNTA (BDNBVAL) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DCOUNTA (BDNBVAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dcounta\/\" \/>\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:35+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DCOUNTA (BDNBVAL) 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\/dcounta\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dcounta\/\",\"name\":\"Fonction DCOUNTA (BDNBVAL) 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:35+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DCOUNTA (BDNBVAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dcounta\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dcounta\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dcounta\/#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\":\"BDNBVAL\"}]},{\"@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 DCOUNTA (BDNBVAL) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DCOUNTA (BDNBVAL) 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\/dcounta\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DCOUNTA (BDNBVAL) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DCOUNTA (BDNBVAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dcounta\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:35+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DCOUNTA (BDNBVAL) 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\/dcounta\/","url":"https:\/\/functiontranslator.com\/fr\/dcounta\/","name":"Fonction DCOUNTA (BDNBVAL) 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:35+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DCOUNTA (BDNBVAL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dcounta\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dcounta\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dcounta\/#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":"BDNBVAL"}]},{"@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\/6494","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=6494"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6494\/revisions"}],"predecessor-version":[{"id":29506,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6494\/revisions\/29506"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}