{"id":6400,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/averagea\/"},"modified":"2021-02-26T08:02:08","modified_gmt":"2021-02-26T08:02:08","slug":"averagea","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/averagea\/","title":{"rendered":"AVERAGEA"},"content":{"rendered":"<h2>Introduction \u00e0 la fonction de calcul de moyenne<\/h2>\n<p>La fonction AVERAGEA dans Excel et Google Sheets est con\u00e7ue pour calculer la moyenne arithm\u00e9tique d&rsquo;un ensemble de donn\u00e9es incluant des nombres, du texte, des valeurs logiques, ou des cellules vides dans une plage donn\u00e9e. Cette fonction est particuli\u00e8rement utile pour les analyses statistiques n\u00e9cessitant la prise en compte de chaque \u00e9l\u00e9ment, y compris les valeurs non num\u00e9riques, faisant d&rsquo;elle un outil essentiel en data analytics.<\/p>\n<h2>D\u00e9tails de la syntaxe<\/h2>\n<p>La syntaxe de base est la suivante :<\/p>\n<pre><code>=AVERAGEA(valeur1, [valeur2], ...)<\/code><\/pre>\n<p>O\u00f9 <code>valeur1<\/code>, <code>valeur2<\/code>, etc., peuvent \u00eatre des nombres, des r\u00e9f\u00e9rences de cellules, des plages de cellules, ou des valeurs textuelles. Les valeurs textuelles sont comptabilis\u00e9es comme 0 et les valeurs logiques TRUE et FALSE sont compt\u00e9es comme 1 et 0, respectivement.<\/p>\n<table>\n<tr>\n<th>Argument<\/th>\n<th>Description<\/th>\n<\/tr>\n<tr>\n<td><code>valeur1<\/code><\/td>\n<td>Obligatoire, la premi\u00e8re valeur, plage de cellules ou cellule \u00e0 inclure dans la moyenne.<\/td>\n<\/tr>\n<tr>\n<td><code>valeur2, ...<\/code><\/td>\n<td>Optionnel, valeurs suppl\u00e9mentaires, plages de cellules ou cellules \u00e0 inclure dans la moyenne.<\/td>\n<\/tr>\n<\/table>\n<h2>Exemples pratiques<\/h2>\n<p>Voici quelques exemples illustrant l&rsquo;utilit\u00e9 de cette fonction :<\/p>\n<h3>Sc\u00e9nario 1: Calcul de moyenne dans une enqu\u00eate<\/h3>\n<p>Durant une enqu\u00eate de satisfaction client, o\u00f9 les r\u00e9ponses \u00e9taient des textes comme \u00ab\u00a0Oui\u00a0\u00bb ou \u00ab\u00a0Non\u00a0\u00bb, des nombres (\u00e9valuation de 1 \u00e0 5), et des r\u00e9ponses manquantes, il est crucial de calculer correctement la moyenne de toutes les r\u00e9ponses.<\/p>\n<pre><code>=AVERAGEA(A1:A5)<\/code><\/pre>\n<p>Si les cellules A1 \u00e0 A5 contiennent \u00ab\u00a0Oui\u00a0\u00bb, 2, \u00ab\u00a0Non\u00a0\u00bb, \u00ab\u00a0\u00a0\u00bb, et 5, la fonction compte \u00ab\u00a0Oui\u00a0\u00bb et \u00ab\u00a0Non\u00a0\u00bb comme 0, ainsi que \u00ab\u00a0\u00a0\u00bb comme 0, et calcule ainsi la moyenne de [0, 2, 0, 0, 5], ce qui donne 1.4.<\/p>\n<h3>Sc\u00e9nario 2: Analyse des donn\u00e9es de participation<\/h3>\n<p>Dans un contexte o\u00f9 certaines donn\u00e9es sont des valeurs bool\u00e9ennes indiquant la participation, et d&rsquo;autres des nombres repr\u00e9sentant le volume d&rsquo;heures particip\u00e9es, cette fonction peut \u00eatre utilis\u00e9e pour obtenir une moyenne globale qui refl\u00e8te tant la pr\u00e9sence que l&rsquo;ampleur de la participation.<\/p>\n<pre><code>=AVERAGEA(B1:B10)<\/code><\/pre>\n<p>Si de B1 \u00e0 B10 nous avons TRUE, FALSE, 3, 4, 2, \u00ab\u00a0\u00a0\u00bb, TRUE, 8, 0, et 5, la fonction calculera la moyenne de [1, 0, 3, 4, 2, 0, 1, 8, 0, 5], r\u00e9sultant en une moyenne de 2.4.<\/p>\n<p>Ces exemples d\u00e9montrent l&rsquo;efficacit\u00e9 de cette fonction dans des contextes o\u00f9 les valeurs non num\u00e9riques doivent \u00eatre int\u00e9gr\u00e9es au calcul des moyennes, offrant ainsi un outil flexible et puissant pour l&rsquo;analyse des donn\u00e9es dans Excel et Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Renvoie la moyenne de ses aRguments, nombRes, texte et valeuRs logiques inclus<\/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-6400","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction AVERAGEA dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction AVERAGEA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;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\/averagea\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction AVERAGEA dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction AVERAGEA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/averagea\/\" \/>\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:08+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction AVERAGEA 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\/averagea\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/averagea\/\",\"name\":\"Fonction AVERAGEA 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:08+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction AVERAGEA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/averagea\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/averagea\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/averagea\/#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\":\"AVERAGEA\"}]},{\"@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 AVERAGEA dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction AVERAGEA 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\/averagea\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction AVERAGEA dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction AVERAGEA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/averagea\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:08+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction AVERAGEA 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\/averagea\/","url":"https:\/\/functiontranslator.com\/fr\/averagea\/","name":"Fonction AVERAGEA 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:08+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction AVERAGEA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/averagea\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/averagea\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/averagea\/#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":"AVERAGEA"}]},{"@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\/6400","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=6400"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6400\/revisions"}],"predecessor-version":[{"id":29412,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6400\/revisions\/29412"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}