{"id":6460,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/nb-vide\/"},"modified":"2021-02-26T08:03:43","modified_gmt":"2021-02-26T08:03:43","slug":"countblank","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/countblank\/","title":{"rendered":"NB.VIDE"},"content":{"rendered":"

Description g\u00e9n\u00e9rale<\/h2>\n

La fonction COUNTBLANK<\/code> (ou NB.VIDE<\/code> en fran\u00e7ais) permet de compter le nombre de cellules vides dans une plage de donn\u00e9es. Elle est particuli\u00e8rement utile dans Excel et Google Sheets pour analyser des ensembles de donn\u00e9es o\u00f9 les entr\u00e9es manquantes jouent un r\u00f4le important.<\/p>\n

Syntaxe et exemples<\/h2>\n

La syntaxe pour cette fonction est la m\u00eame dans Excel et Google Sheets :<\/p>\n

NB.VIDE(plage)<\/code><\/pre>\n
O\u00f9 plage<\/em> correspond aux cellules que vous souhaitez examiner.<\/p>\n
Exemple 1:<\/strong><\/p>\n
A 1 10 2 3 20 4 5<\/code><\/pre>\n
Si nous utilisons la formule =NB.VIDE(A1:A5)<\/code>, le r\u00e9sultat sera 3, correspondant aux trois cellules vides de la plage A1 \u00e0 A5.<\/p>\n
Exemple 2:<\/strong><\/p>\n
A B C 1 100 200 300 2 400 500 3 600 700<\/code><\/pre>\n
En appliquant =NB.VIDE(A1:C3)<\/code>, le r\u00e9sultat indiqu\u00e9 par Excel sera 2 pour les deux cellules vides B2 et C3.<\/p>\n
Cas pratiques d’utilisation<\/h2>\n
Analyse des donn\u00e9es manquantes<\/h2>\n
Que ce soit dans les bases de donn\u00e9es ou lors de la collecte de donn\u00e9es, certaines cellules peuvent demeurer vides. Savoir rapidement combien de cellules sont vides peut s’av\u00e9rer crucial pour l\u2019analyse statistique ou la prise de d\u00e9cisions.<\/p>\n
Exemple :<\/strong><\/p>\n
Echantillon 1 25 2 3 30 4 35 5 6 40<\/code><\/pre>\n
Pour d\u00e9terminer le nombre de valeurs manquantes dans la colonne A ci-dessus :<\/p>\n
=NB.VIDE(A1:A6)<\/code><\/pre>\n
Le r\u00e9sultat sera 2, indiquant deux valeurs manquantes dans votre \u00e9chantillon de donn\u00e9es.<\/p>\n
Nettoyage de donn\u00e9es<\/h2>\n
Le nettoyage des ensembles de donn\u00e9es est souvent une \u00e9tape pr\u00e9liminaire essentielle avant leur analyse. Identifier et \u00e9valuer le nombre de cellules vides peut aider \u00e0 d\u00e9cider des actions \u00e0 entreprendre, par exemple effacer les lignes ou les colonnes contenant trop de donn\u00e9es manquantes.<\/p>\n
Exemple :<\/strong><\/p>\n\n\n\n\n\n
ID<\/th>\nNom<\/th>\nAdresse<\/th>\nCode postal<\/th>\n<\/tr>\n
1<\/td>\nJean<\/td>\nRue de Paris<\/td>\n75008<\/td>\n<\/tr>\n
2<\/td>\nMarc<\/td>\n<\/td>\n13001<\/td>\n<\/tr>\n
3<\/td>\n<\/td>\nRue de Lyon<\/td>\n<\/td>\n<\/tr>\n<\/table>\n
Pour compter les cellules vides dans cet exemple, utilisez :<\/p>\n
=NB.VIDE(B2:D4)<\/code><\/pre>\n
Le r\u00e9sultat sera 3, signifiant que trois cellules vides pourraient n\u00e9cessiter une intervention lors du nettoyage des donn\u00e9es.<\/p>\n
 Cette description offre une explication claire de la fonction, en plus de fournir des exemples concrets montrant comment l’appliquer dans divers contextes de manipulation de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
Compte le nombre de Cellules vides dans une plage<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[315],"tags":[],"class_list":["post-6460","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction COUNTBLANK (NB.VIDE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction COUNTBLANK (NB.VIDE) 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\/countblank\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction COUNTBLANK (NB.VIDE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction COUNTBLANK (NB.VIDE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/countblank\/\" \/>\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:03:43+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction COUNTBLANK (NB.VIDE) 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\/countblank\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/countblank\/\",\"name\":\"Fonction COUNTBLANK (NB.VIDE) 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:03:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction COUNTBLANK (NB.VIDE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/countblank\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/countblank\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/countblank\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistiques\",\"item\":\"https:\/\/functiontranslator.com\/fr\/statistiques\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NB.VIDE\"}]},{\"@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 COUNTBLANK (NB.VIDE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction COUNTBLANK (NB.VIDE) 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\/countblank\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction COUNTBLANK (NB.VIDE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction COUNTBLANK (NB.VIDE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/countblank\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction COUNTBLANK (NB.VIDE) 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\/countblank\/","url":"https:\/\/functiontranslator.com\/fr\/countblank\/","name":"Fonction COUNTBLANK (NB.VIDE) 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:03:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction COUNTBLANK (NB.VIDE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/countblank\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/countblank\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/countblank\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Statistiques","item":"https:\/\/functiontranslator.com\/fr\/statistiques\/"},{"@type":"ListItem","position":3,"name":"NB.VIDE"}]},{"@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\/6460","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=6460"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6460\/revisions"}],"predecessor-version":[{"id":29472,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6460\/revisions\/29472"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}