{"id":6663,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction-min-si\/"},"modified":"2021-02-26T08:10:21","modified_gmt":"2021-02-26T08:10:21","slug":"minifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/minifs\/","title":{"rendered":"min.si"},"content":{"rendered":"

Pr\u00e9sentation g\u00e9n\u00e9rale<\/h2>\n

La fonction MINIFS dans Microsoft Excel et Google Sheets permet de trouver la valeur minimale dans une s\u00e9rie de donn\u00e9es qui satisfait \u00e0 certaines conditions sp\u00e9cifi\u00e9es. Cet outil s’av\u00e8re particuli\u00e8rement utile dans l\u2019analyse de donn\u00e9es pour isoler des \u00e9l\u00e9ments qui r\u00e9pondent \u00e0 des crit\u00e8res pr\u00e9d\u00e9finis.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe pour la fonction MINIFS est la suivante :<\/p>\n

=MINIFS(plage_min, plage_crit\u00e8re1, crit\u00e8re1, [plage_crit\u00e8re2, crit\u00e8re2], ...)<\/code><\/pre>\n
    \n
  • plage_min<\/strong> : La plage de cellules \u00e0 partir de laquelle la valeur minimale est recherch\u00e9e.<\/li>\n
  • plage_crit\u00e8re1, plage_crit\u00e8re2,…<\/strong> : Les plages o\u00f9 les crit\u00e8res doivent \u00eatre v\u00e9rifi\u00e9s.<\/li>\n
  • crit\u00e8re1, crit\u00e8re2,…<\/strong> : Les conditions que les valeurs doivent respecter dans les plages de crit\u00e8res sp\u00e9cifi\u00e9es. Ces crit\u00e8res peuvent \u00eatre des chiffres, du texte, ou des expressions.<\/li>\n<\/ul>\n
    Exemples concrets d\u2019utilisation<\/h2>\n
    Voici des illustrations de l’utilisation de MINIFS pour r\u00e9pondre \u00e0 des exigences sp\u00e9cifiques dans Excel et Google Sheets :<\/p>\n\n\n\n\n
    Plage de donn\u00e9es<\/th>\nPlage de crit\u00e8res<\/th>\nCrit\u00e8res<\/th>\nFormule<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    A1:A10<\/td>\nB1:B10<\/td>\n\u00ab\u00a0>20\u00a0\u00bb<\/td>\n=MINIFS(A1:A10, B1:B10, \">20\")<\/code><\/td>\nValeur minimale dans la colonne A pour les valeurs de la colonne B sup\u00e9rieures \u00e0 20<\/td>\n<\/tr>\n
    C1:C15<\/td>\nD1:D15<\/td>\n\u00ab\u00a0=XYZ\u00a0\u00bb<\/td>\n=MINIFS(C1:C15, D1:D15, \"=XYZ\")<\/code><\/td>\nValeur minimale dans la colonne C pour les valeurs de la colonne D \u00e9gales \u00e0 \u00ab\u00a0XYZ\u00a0\u00bb<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios pratiques d’application<\/h2>\n
    Cas n\u00b01 : Bilan de ventes<\/h3>\n
    Consid\u00e9rons un tableau de ventes o\u00f9 la colonne A indique les montants des ventes en euros et la colonne B les noms des vendeurs. Pour trouver la vente minimale de \u00ab\u00a0Jean\u00a0\u00bb, la formule serait :<\/p>\n
    =MINIFS(A2:A100, B2:B100, \"=Jean\")<\/code><\/pre>\n
    Cette formule identifie la vente la plus basse r\u00e9alis\u00e9e par Jean.<\/p>\n
    Cas n\u00b02 : Analyse Acad\u00e9mique<\/h3>\n
    Dans une universit\u00e9, si les notes sont list\u00e9es dans la colonne E et les mati\u00e8res correspondantes dans la colonne F, pour trouver la note minimale en \u00ab\u00a0Math\u00e9matiques\u00a0\u00bb, la formule appropri\u00e9e serait :<\/p>\n
    =MINIFS(E1:E50, F1:F50, \"Math\u00e9matiques\")<\/code><\/pre>\n
    Cette commande d\u00e9termine la note la plus basse obtenue en Math\u00e9matiques.<\/p>\n
    Conclusion<\/h2>\n
    L’emploi de la fonction MINIFS est pertinent pour le filtrage et l’analyse de donn\u00e9es selon des crit\u00e8res sp\u00e9cifiques aussi bien dans Excel que Google Sheets. Elle facilite l\u2019analyse de donn\u00e9es dans divers contextes professionnels, acad\u00e9miques et autres secteurs.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeur minimale parmi les cellules sp\u00e9cifi\u00e9es par un ensemble de conditions ou 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-6663","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction MINIFS (min.si) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MINIFS (min.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\/minifs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MINIFS (min.si) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MINIFS (min.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\/minifs\/\" \/>\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:10:21+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MINIFS (min.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\/minifs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/minifs\/\",\"name\":\"Fonction MINIFS (min.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:10:21+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MINIFS (min.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/minifs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/minifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/minifs\/#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\":\"min.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 MINIFS (min.si) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MINIFS (min.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\/minifs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MINIFS (min.si) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MINIFS (min.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/minifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:21+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MINIFS (min.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\/minifs\/","url":"https:\/\/functiontranslator.com\/fr\/minifs\/","name":"Fonction MINIFS (min.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:10:21+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MINIFS (min.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/minifs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/minifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/minifs\/#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":"min.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\/6663","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=6663"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6663\/revisions"}],"predecessor-version":[{"id":29674,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6663\/revisions\/29674"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}