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

Description de la fonction MOYENNE.SI<\/h2>\n

La fonction MOYENNE.SI<\/code> calcule la moyenne arithm\u00e9tique des nombres dans une plage sp\u00e9cifi\u00e9e qui r\u00e9pondent \u00e0 un crit\u00e8re d\u00e9fini. Cette fonction est particuli\u00e8rement utile pour analyser des sous-ensembles de donn\u00e9es au sein d\u2019un ensemble plus vaste.<\/p>\n

Syntaxe de MOYENNE.SI<\/h2>\n
=MOYENNE.SI(plage; crit\u00e8re; [plage_moyenne])<\/code><\/pre>\n
    \n
  • plage<\/strong> : La plage de cellules o\u00f9 le crit\u00e8re est \u00e9valu\u00e9.<\/li>\n
  • crit\u00e8re<\/strong> : Le crit\u00e8re que les cellules doivent satisfaire pour \u00eatre prises en compte dans le calcul de la moyenne. Ce crit\u00e8re peut \u00eatre un nombre, une expression, une r\u00e9f\u00e9rence de cellule, ou un texte formant une expression logique.<\/li>\n
  • plage_moyenne<\/strong> (facultative) : La plage de cellules dont la moyenne est effectivement calcul\u00e9e. Si non sp\u00e9cifi\u00e9e, elle est identique \u00e0 la plage-crit\u00e8re.<\/li>\n<\/ul>\n
    Exemples d’application<\/h2>\n\n\n\n\n
    Donn\u00e9es<\/th>\nFormule<\/th>\nR\u00e9sultat<\/th>\nDescription<\/th>\n<\/tr>\n
    A1:A5 : 10, 20, 30, 40, 50<\/td>\n=MOYENNE.SI(A1:A5; \">20\")<\/code><\/td>\n40<\/td>\nMoyenne des valeurs sup\u00e9rieures \u00e0 20.<\/td>\n<\/tr>\n
    B1:B5 : 5, 10, 15, 20, 25<\/td>\n=MOYENNE.SI(B1:B5; \"<=15\"; B1:B5)<\/code><\/td>\n10<\/td>\nMoyenne des valeurs inf\u00e9rieures ou \u00e9gales \u00e0 15 dans la plage B1:B5.<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios pratiques<\/h2>\n
    Imaginons une liste de ventes mensuelles d’une entreprise o\u00f9 nous souhaitons calculer la moyenne des ventes d\u00e9passant un certain seuil.<\/p>\n
    Donn\u00e9es:<\/strong> A1: Mois, B1: Ventes A2: Janvier, B2: 5000 A3: F\u00e9vrier, B3: 6000 A4: Mars, B4: 4000 A5: Avril, B5: 7000 Formule:<\/strong> =MOYENNE.SI(B2:B5; \">5000\") R\u00e9sultat:<\/strong> 6500 Commentaire:<\/strong> Cette formule calcule la moyenne des ventes sup\u00e9rieures \u00e0 5000.<\/code><\/pre>\n
    Dans un autre sc\u00e9nario, examinons les scores de satisfaction des clients, en cherchant \u00e0 conna\u00eetre la moyenne des scores selon un crit\u00e8re sp\u00e9cifique.<\/p>\n
    Donn\u00e9es:<\/strong> C1: Clients, D1: Scores C2: Client A, D2: 80 C3: Client B, D3: 90 C4: Client C, D4: 70 C5: Client D, D5: 85 Formule:<\/strong> =MOYENNE.SI(D2:D5; \">75\") R\u00e9sultat:<\/strong> 85 Commentaire:<\/strong> La formule calcule la moyenne des scores sup\u00e9rieurs \u00e0 75.<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la moyenne (aRithm\u00e9tique) de toutes les cellules d\u2019une plage qui R\u00e9pondent \u00e0 des cRit\u00e8Res donn\u00e9s<\/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-6401","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction AVERAGEIF (MOYENNE.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction AVERAGEIF (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\/averageif\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction AVERAGEIF (MOYENNE.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction AVERAGEIF (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\/averageif\/\" \/>\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:09+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction AVERAGEIF (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\/averageif\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/averageif\/\",\"name\":\"Fonction AVERAGEIF (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:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction AVERAGEIF (MOYENNE.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/averageif\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/averageif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/averageif\/#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 AVERAGEIF (MOYENNE.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction AVERAGEIF (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\/averageif\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction AVERAGEIF (MOYENNE.SI) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction AVERAGEIF (MOYENNE.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/averageif\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction AVERAGEIF (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\/averageif\/","url":"https:\/\/functiontranslator.com\/fr\/averageif\/","name":"Fonction AVERAGEIF (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:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction AVERAGEIF (MOYENNE.SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/averageif\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/averageif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/averageif\/#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\/6401","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=6401"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6401\/revisions"}],"predecessor-version":[{"id":29413,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6401\/revisions\/29413"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}