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

La fonction NB.SI.ENS<\/strong> dans MS Excel et Google Sheets est un outil indispensable pour compter les cellules qui satisfont \u00e0 plusieurs crit\u00e8res simultan\u00e9ment. Elle est extr\u00eamement pratique pour l’analyse de donn\u00e9es complexes, permettant des comptages conditionnels bas\u00e9s sur diverses conditions.<\/p>\n

Syntaxe et Exemples<\/h2>\n

La syntaxe de la fonction NB.SI.ENS est la suivante :<\/p>\n

NB.SI.ENS(plage_crit\u00e8re1; crit\u00e8re1; [plage_crit\u00e8re2; crit\u00e8re2]; ...)<\/code><\/pre>\n
Voici les composants de cette fonction :<\/p>\n
    \n
  • plage_crit\u00e8re1, plage_crit\u00e8re2, \u2026<\/strong> : Ce sont les plages de cellules sur lesquelles les crit\u00e8res sp\u00e9cifi\u00e9s sont appliqu\u00e9s.<\/li>\n
  • crit\u00e8re1, crit\u00e8re2, \u2026<\/strong> : Ce sont les conditions que doivent remplir les cellules pour \u00eatre compt\u00e9es. Ces conditions peuvent \u00eatre des nombres, du texte ou m\u00eame des formules.<\/li>\n<\/ul>\n
    Un exemple concret :<\/p>\n
    =NB.SI.ENS(A1:A10, \">20\", B1:B10, \"Paris\")<\/code><\/pre>\n
    Cette formule compte le nombre de cellules dans la plage A1 \u00e0 A10 contenant des valeurs sup\u00e9rieures \u00e0 20 tout en correspondant \u00e0 \u00ab\u00a0Paris\u00a0\u00bb dans la plage B1 \u00e0 B10.<\/p>\n
    Sc\u00e9narios pratiques d’utilisation<\/h2>\n
    Exemple 1: Analyse des ventes<\/h2>\n
    Supposons que vous disposez d’une liste de transactions de vente dans diff\u00e9rentes villes pour divers produits. Vous voulez d\u00e9terminer combien de fois un produit sp\u00e9cifique a \u00e9t\u00e9 vendu dans une ville donn\u00e9e, pour un montant d\u00e9passant un certain seuil.<\/p>\n
    Donn\u00e9es :<\/p>\n\n\n\n\n\n
    Produit<\/th>\nVille<\/th>\nMontant<\/th>\n<\/tr>\n
    Chaise<\/td>\nParis<\/td>\n25<\/td>\n<\/tr>\n
    Table<\/td>\nLyon<\/td>\n45<\/td>\n<\/tr>\n
    Chaise<\/td>\nParis<\/td>\n30<\/td>\n<\/tr>\n<\/table>\n
    Solution :<\/p>\n
    =NB.SI.ENS(B2:B4, \"Paris\", A2:A4, \"Chaise\", C2:C4, \">20\")<\/code><\/pre>\n
    Cette formule renvoie le nombre de chaises vendues \u00e0 Paris pour un montant sup\u00e9rieur \u00e0 20\u20ac.<\/p>\n
    Exemple 2: Suivi des performances scolaires<\/h2>\n
    En tant qu’enseignant, vous souhaitez identifier rapidement le nombre d’\u00e9l\u00e8ves ayant obtenu une note au-dessus de la moyenne dans diff\u00e9rentes mati\u00e8res.<\/p>\n
    Donn\u00e9es :<\/p>\n\n\n\n\n\n
    \u00c9tudiant<\/th>\nNote Math<\/th>\nNote Litt\u00e9rature<\/th>\n<\/tr>\n
    Alice<\/td>\n15<\/td>\n12<\/td>\n<\/tr>\n
    Bob<\/td>\n11<\/td>\n19<\/td>\n<\/tr>\n
    Charlie<\/td>\n16<\/td>\n14<\/td>\n<\/tr>\n<\/table>\n
    Solution :<\/p>\n
    =NB.SI.ENS(B2:B4, \">14\", C2:C4, \">14\")<\/code><\/pre>\n
    Cette formule compte les \u00e9tudiants ayant obtenu plus de 14 \u00e0 la fois en Math\u00e9matiques et en Litt\u00e9rature.<\/p>\n
    L’utilisation de la fonction NB.SI.ENS offre ainsi la capacit\u00e9 d’aborder efficacement une vari\u00e9t\u00e9 de sc\u00e9narios d’analyse de donn\u00e9es, facilitant une compr\u00e9hension plus approfondie et fournissant des insights pr\u00e9cieux pour la prise de d\u00e9cision dans diff\u00e9rents contextes professionnels et \u00e9ducatifs.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Compte le nombre de Cellules \u00e0 l\u2019int\u00e9rieur d\u2019une plage qui r\u00e9pondent \u00e0 plusieurs 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":[315],"tags":[],"class_list":["post-6462","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction COUNTIFS (NB.si) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction COUNTIFS (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\/countifs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction COUNTIFS (NB.si) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction COUNTIFS (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\/countifs\/\" \/>\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:45+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction COUNTIFS (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\/countifs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/countifs\/\",\"name\":\"Fonction COUNTIFS (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:45+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction COUNTIFS (NB.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/countifs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/countifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/countifs\/#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 COUNTIFS (NB.si) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction COUNTIFS (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\/countifs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction COUNTIFS (NB.si) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction COUNTIFS (NB.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/countifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:45+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction COUNTIFS (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\/countifs\/","url":"https:\/\/functiontranslator.com\/fr\/countifs\/","name":"Fonction COUNTIFS (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:45+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction COUNTIFS (NB.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/countifs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/countifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/countifs\/#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\/6462","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=6462"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6462\/revisions"}],"predecessor-version":[{"id":29474,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6462\/revisions\/29474"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}