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

La fonction COUNTIF<\/strong> en anglais, ou NB.SI<\/strong> en fran\u00e7ais, est utilis\u00e9e dans Excel et Google Sheets pour compter le nombre de cellules qui r\u00e9pondent \u00e0 un crit\u00e8re sp\u00e9cifique. Elle s’av\u00e8re particuli\u00e8rement utile pour l’analyse de donn\u00e9es, permettant de quantifier facilement des \u00e9l\u00e9ments qui satisfont \u00e0 certaines conditions au sein d’un jeu de donn\u00e9es.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction NB.SI :<\/p>\n

=NB.SI(plage; crit\u00e8re)<\/code><\/pre>\n
    \n
  • plage<\/strong> : d\u00e9finit l’ensemble des cellules sur lesquelles le crit\u00e8re sera appliqu\u00e9.<\/li>\n
  • crit\u00e8re<\/strong> : sp\u00e9cifie la condition que les cellules doivent remplir pour \u00eatre compt\u00e9es. Ce crit\u00e8re peut \u00eatre un nombre, une expression ou un texte qui \u00e9tablit les cellules \u00e0 consid\u00e9rer.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n\n\n\n\n
    Formule<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    =NB.SI(A1:A10, \">20\")<\/code><\/td>\nCompte le nombre de cellules dont la valeur est sup\u00e9rieure \u00e0 20 dans la plage A1:A10.<\/td>\nNombre de cellules > 20<\/td>\n<\/tr>\n
    =NB.SI(A1:A10, \"Pommes\")<\/code><\/td>\nCompte le nombre de cellules contenant le texte \u00ab\u00a0Pommes\u00a0\u00bb dans la plage A1:A10.<\/td>\nNombre de cellules contenant \u00ab\u00a0Pommes\u00a0\u00bb<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios pratiques<\/h2>\n
    Voici deux exemples concrets o\u00f9 la fonction NB.SI peut s’av\u00e9rer extr\u00eamement b\u00e9n\u00e9fique :<\/p>\n
    1. Comptage des valeurs sup\u00e9rieures \u00e0 un seuil<\/h2>\n
    Si vous disposez d’une liste de scores d’\u00e9tudiants et souhaitez d\u00e9terminer combien ont obtenu plus de 75 points, utilisez la formule suivante :<\/p>\n
    =NB.SI(B2:B100, \">75\")<\/code><\/pre>\n
    Cette formule permet de compter rapidement le nombre de scores sup\u00e9rieurs \u00e0 75 dans la plage B2 \u00e0 B100, facilitant ainsi l’\u00e9valuation des performances des \u00e9tudiants sans n\u00e9cessiter de tri ou de filtre des donn\u00e9es.<\/p>\n
    2. Comptage d’occurrences sp\u00e9cifiques<\/h2>\n
    Si vous g\u00e9rez un inventaire et d\u00e9sirez savoir combien d’articles sont pr\u00e9cis\u00e9ment de type \u00ab\u00a0Stylo\u00a0\u00bb, utilisez cette formule :<\/p>\n
    =NB.SI(C2:C100, \"Stylo\")<\/code><\/pre>\n
    Elle examinera la colonne C, de C2 \u00e0 C100, et comptera le nombre de fois o\u00f9 le terme \u00ab\u00a0Stylo\u00a0\u00bb appara\u00eet. Cette m\u00e9thode est id\u00e9ale pour la gestion de stock et la planification des approvisionnements futurs.<\/p>\n
    Ces sc\u00e9narios illustrant l’utilisation de NB.SI d\u00e9montrent comment cette fonction peut simplifier consid\u00e9rablement la gestion de donn\u00e9es et l’analyse quantitative dans Excel et Google Sheets gr\u00e2ce \u00e0 une simple formule.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Compte le nombre de Cellules qui r\u00e9pondent \u00e0 un Crit\u00e8re donn\u00e9 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-6461","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction COUNTIF (NB.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction COUNTIF (NB.SI) 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\/countif\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction COUNTIF (NB.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction COUNTIF (NB.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/countif\/\" \/>\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:44+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction COUNTIF (NB.SI) 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\/countif\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/countif\/\",\"name\":\"Fonction COUNTIF (NB.SI) 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:44+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction COUNTIF (NB.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/countif\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/countif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/countif\/#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.SI\"}]},{\"@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 COUNTIF (NB.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction COUNTIF (NB.SI) 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\/countif\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction COUNTIF (NB.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction COUNTIF (NB.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/countif\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:44+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction COUNTIF (NB.SI) 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\/countif\/","url":"https:\/\/functiontranslator.com\/fr\/countif\/","name":"Fonction COUNTIF (NB.SI) 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:44+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction COUNTIF (NB.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/countif\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/countif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/countif\/#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.SI"}]},{"@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\/6461","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=6461"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6461\/revisions"}],"predecessor-version":[{"id":29473,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6461\/revisions\/29473"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}