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

Description de la fonction<\/h2>\n

La fonction AVERAGEIFS<\/code> dans Excel calcule la moyenne arithm\u00e9tique des cellules qui r\u00e9pondent \u00e0 plusieurs crit\u00e8res sp\u00e9cifiques. Elle est particuli\u00e8rement utile pour l’analyse de donn\u00e9es complexes n\u00e9cessitant la prise en compte de multiples conditions pour d\u00e9terminer une moyenne.<\/p>\n

Syntaxe<\/h2>\n

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

=AVERAGEIFS(plage_moyenne, plage_crit\u00e8res1, crit\u00e8res1, [plage_crit\u00e8res2, crit\u00e8res2], ...)<\/code><\/pre>\n
    \n
  • plage_moyenne<\/strong> : La plage de cellules dont la moyenne doit \u00eatre calcul\u00e9e.<\/li>\n
  • plage_crit\u00e8res1, plage_crit\u00e8res2, …<\/strong> : Les plages o\u00f9 les crit\u00e8res sp\u00e9cifiques sont v\u00e9rifi\u00e9s pour d\u00e9cider si les cellules de la plage_moyenne<\/strong> doivent \u00eatre incluses dans le calcul de la moyenne.<\/li>\n
  • crit\u00e8res1, crit\u00e8res2, …<\/strong> : Les crit\u00e8res qui d\u00e9finissent les cellules \u00e0 inclure dans la moyenne. Les crit\u00e8res peuvent inclure des nombres, du texte, des expressions ou des r\u00e9f\u00e9rences de cellules sp\u00e9cifiques.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Examinons le tableau suivant pour illustrer deux exemples :<\/p>\n\n\n\n\n\n\n
    Produit<\/th>\nVentes<\/th>\nR\u00e9gion<\/th>\n<\/tr>\n
    Produit A<\/td>\n120<\/td>\nNord<\/td>\n<\/tr>\n
    Produit B<\/td>\n150<\/td>\nSud<\/td>\n<\/tr>\n
    Produit A<\/td>\n100<\/td>\nSud<\/td>\n<\/tr>\n
    Produit C<\/td>\n200<\/td>\nNord<\/td>\n<\/tr>\n<\/table>\n
    =AVERAGEIFS(B2:B5, A2:A5, \"Produit A\", C2:C5, \"Sud\")<\/code><\/pre>\n
    Dans cet exemple, la formule calcule la moyenne des ventes du \u00ab\u00a0Produit A\u00a0\u00bb dans la r\u00e9gion \u00ab\u00a0Sud\u00a0\u00bb. Le r\u00e9sultat est 100, car c’est la seule donn\u00e9e qui r\u00e9pond aux crit\u00e8res \u00e9tablis.<\/p>\n
    Cas d’utilisation pratiques<\/h2>\n
    Calcul de la moyenne conditionnelle : Exemple de notation<\/h2>\n
    Consid\u00e9rons un enseignant d\u00e9sirant calculer la moyenne des notes des \u00e9l\u00e8ves ayant obtenu plus de 10 et appartenant \u00e0 la section litt\u00e9raire :<\/p>\n\n\n\n\n\n\n
    \u00c9l\u00e8ve<\/th>\nNote<\/th>\nSection<\/th>\n<\/tr>\n
    Marie<\/td>\n15<\/td>\nLitt\u00e9raire<\/td>\n<\/tr>\n
    Jean<\/td>\n8<\/td>\nScientifique<\/td>\n<\/tr>\n
    Anne<\/td>\n12<\/td>\nLitt\u00e9raire<\/td>\n<\/tr>\n
    Pierre<\/td>\n9<\/td>\nLitt\u00e9raire<\/td>\n<\/tr>\n<\/table>\n
    =AVERAGEIFS(B2:B5, B2:B5, \">10\", C2:C5, \"Litt\u00e9raire\")<\/code><\/pre>\n
    Cette formule calculera la moyenne des notes de Marie et Anne, \u00e9tant donn\u00e9 qu’elles remplissent les deux crit\u00e8res requis. Le r\u00e9sultat est de 13.5.<\/p>\n
    Analyse des performances de vente<\/h2>\n
    Un responsable souhaite \u00e9valuer la performance moyenne des ventes dans les r\u00e9gions o\u00f9 chaque vente d\u00e9passe 120 unit\u00e9s. Reprenons le tableau de ventes initial pour cet exemple :<\/p>\n
    =AVERAGEIFS(B2:B5, B2:B5, \">120\", C2:C5, \"Nord\")<\/code><\/pre>\n
    Ici, la moyenne est calcul\u00e9e uniquement pour le Produit C dans la r\u00e9gion Nord, o\u00f9 les ventes sont de 200. Aucune autre vente ne surpassant 120 unit\u00e9s dans cette r\u00e9gion, le r\u00e9sultat est donc de 200.<\/p>\n
    La fonction AVERAGEIFS<\/code> permet d’analyser divers sc\u00e9narios impliquant plusieurs conditions, offrant ainsi une grande flexibilit\u00e9 et efficacit\u00e9 dans l’analyse de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la moyenne (aRithm\u00e9tique) de toutes les cellules 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-6402","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction AVERAGEIFS (moyenne.si) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction AVERAGEIFS (moyenne.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\/averageifs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction AVERAGEIFS (moyenne.si) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction AVERAGEIFS (moyenne.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\/averageifs\/\" \/>\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:02:11+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction AVERAGEIFS (moyenne.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\/averageifs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/averageifs\/\",\"name\":\"Fonction AVERAGEIFS (moyenne.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:02:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction AVERAGEIFS (moyenne.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/averageifs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/averageifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/averageifs\/#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\":\"moyenne.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 AVERAGEIFS (moyenne.si) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction AVERAGEIFS (moyenne.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\/averageifs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction AVERAGEIFS (moyenne.si) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction AVERAGEIFS (moyenne.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/averageifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction AVERAGEIFS (moyenne.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\/averageifs\/","url":"https:\/\/functiontranslator.com\/fr\/averageifs\/","name":"Fonction AVERAGEIFS (moyenne.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:02:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction AVERAGEIFS (moyenne.si) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/averageifs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/averageifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/averageifs\/#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":"moyenne.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\/6402","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=6402"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6402\/revisions"}],"predecessor-version":[{"id":29414,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6402\/revisions\/29414"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}