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

Introduction \u00e0 la fonction de calcul conditionnel du maximum<\/h2>\n

Dans Microsoft Excel et Google Sheets, la fonction de calcul conditionnel du maximum est extr\u00eamement utile pour analyser et extraire des valeurs maximales de grands ensembles de donn\u00e9es selon des conditions sp\u00e9cifiques.<\/p>\n

Syntaxe et exemples d’application<\/h2>\n

Voici la syntaxe de cette fonction :<\/p>\n

=MAXIFS(plage_max, plage_crit\u00e8res1, crit\u00e8re1, [plage_crit\u00e8res2, crit\u00e8re2], ...)<\/code><\/pre>\n
    \n
  • plage_max<\/strong> : R\u00e9f\u00e9rence \u00e0 la plage de cellules dont vous recherchez la valeur maximale.<\/li>\n
  • plage_crit\u00e8res1, plage_crit\u00e8res2, …<\/strong>: R\u00e9f\u00e9rences aux plages o\u00f9 les crit\u00e8res sp\u00e9cifi\u00e9s doivent \u00eatre v\u00e9rifi\u00e9s.<\/li>\n
  • crit\u00e8re1, crit\u00e8re2, …<\/strong>: Les conditions sp\u00e9cifiques que les valeurs dans plage_max<\/em> doivent satisfaire pour \u00eatre incluses dans le calcul du maximum.<\/li>\n<\/ul>\n
    Prenons un exemple pour mieux comprendre son utilisation :<\/p>\n\n\n\n\n
    Produit<\/th>\nVentes Janvier<\/th>\nVentes F\u00e9vrier<\/th>\n<\/tr>\n
    Produit A<\/td>\n150<\/td>\n200<\/td>\n<\/tr>\n
    Produit B<\/td>\n300<\/td>\n250<\/td>\n<\/tr>\n<\/table>\n
    Pour d\u00e9terminer la valeur maximale des ventes en janvier pour les produits qui ont r\u00e9alis\u00e9 plus de 200 ventes en f\u00e9vrier, la formule serait :<\/p>\n
    =MAXIFS(B2:B3, C2:C3, \">200\")<\/code><\/pre>\n
    Cela renvoie 300<\/strong>, qui est la valeur maximale des ventes en janvier pour les produits r\u00e9pondant au crit\u00e8re.<\/p>\n
    Sc\u00e9narios pratiques<\/h2>\n
    S\u00e9lection de la valeur de vente maximale par cat\u00e9gorie<\/h2>\n
    Imaginez un tableau des ventes de produits class\u00e9s par cat\u00e9gorie. Pour trouver la valeur maximale de vente dans la cat\u00e9gorie \u00ab\u00a0\u00c9lectronique\u00a0\u00bb, utilisez :<\/p>\n
    =MAXIFS(B2:B100, A2:A100, \"\u00c9lectronique\")<\/code><\/pre>\n
    Cette formule affiche la vente maximale dans la cat\u00e9gorie \u00ab\u00a0\u00c9lectronique\u00a0\u00bb en s\u00e9lectionnant les valeurs dans B2:B100<\/em> correspondant \u00e0 \u00ab\u00a0\u00c9lectronique\u00a0\u00bb dans A2:A100<\/em>.<\/p>\n
    Analyse de performance des \u00e9l\u00e8ves<\/h2>\n
    Consid\u00e9rons un tableau r\u00e9pertoriant les notes des \u00e9l\u00e8ves par mati\u00e8re. Pour trouver la note maximale en math\u00e9matiques des \u00e9l\u00e8ves de la classe ’10A’, utilisez :<\/p>\n
    =MAXIFS(B2:B200, A2:A200, \"Math\u00e9matiques\", C2:C200, \"10A\")<\/code><\/pre>\n
    Cette formule renvoie la note maximale en math\u00e9matiques pour les \u00e9l\u00e8ves de la classe ’10A’, en filtrant les valeurs dans B2:B200<\/em> pour les entr\u00e9es correspondant \u00e0 ‘Math\u00e9matiques’ en A2:A200<\/em> et ’10A’ en C2:C200<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeur maximale 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-6657","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction MAXIFS (max.si) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MAXIFS (max.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\/maxifs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MAXIFS (max.si) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MAXIFS (max.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\/maxifs\/\" \/>\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:12+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MAXIFS (max.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\/maxifs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/maxifs\/\",\"name\":\"Fonction MAXIFS (max.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:12+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MAXIFS (max.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/maxifs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/maxifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/maxifs\/#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\":\"max.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 MAXIFS (max.si) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MAXIFS (max.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\/maxifs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MAXIFS (max.si) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MAXIFS (max.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/maxifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:12+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MAXIFS (max.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\/maxifs\/","url":"https:\/\/functiontranslator.com\/fr\/maxifs\/","name":"Fonction MAXIFS (max.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:12+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MAXIFS (max.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/maxifs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/maxifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/maxifs\/#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":"max.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\/6657","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=6657"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6657\/revisions"}],"predecessor-version":[{"id":29668,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6657\/revisions\/29668"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}