{"id":6383,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/agregat\/"},"modified":"2021-02-26T08:01:42","modified_gmt":"2021-02-26T08:01:42","slug":"aggregate","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/aggregate\/","title":{"rendered":"AGREGAT"},"content":{"rendered":"

Introduction \u00e0 la Fonction AGREGAT<\/h2>\n

La fonction AGREGAT est extr\u00eamement utile et efficace pour r\u00e9aliser des calculs sur des ensembles de donn\u00e9es, tout en omettant les erreurs et les valeurs masqu\u00e9es. Cette fonction, disponible dans MS Excel, se distingue par sa flexibilit\u00e9 \u00e0 ex\u00e9cuter diverses op\u00e9rations en excluant sp\u00e9cifiquement les erreurs ou les valeurs cach\u00e9es.<\/p>\n

Syntaxe et Options<\/h2>\n

La syntaxe de la fonction AGREGAT est:<\/p>\n

AGREGAT(fonction_num, options, intervalle1, [intervalle2], ...)<\/code><\/pre>\n
O\u00f9:<\/p>\n
    \n
  • fonction_num<\/strong> : Num\u00e9ro indiquant l’op\u00e9ration \u00e0 effectuer. Par exemple, 1 pour MOYENNE, 2 pour COMPTER, etc.<\/li>\n
  • options<\/strong> : Num\u00e9ro sp\u00e9cifiant les types de valeurs \u00e0 inclure ou \u00e0 exclure du calcul. Par exemple, 0 pour ignorer les valeurs masqu\u00e9es, 6 pour ignorer les erreurs.<\/li>\n
  • intervalle1<\/strong> : Premi\u00e8re plage de cellules utilis\u00e9e pour le calcul.<\/li>\n
  • intervalle2, …<\/strong> : Autres plages de cellules additionnelles (facultatives).<\/li>\n<\/ul>\n
    Exemple de Base<\/h2>\n
    Imaginons une liste de nombres dans une colonne A1:A10, avec certaines valeurs masqu\u00e9es. Pour calculer la moyenne tout en ignorant les valeurs masqu\u00e9es :<\/p>\n
    =AGREGAT(1, 5, A1:A10)<\/code><\/pre>\n
    Cette formule utilise fonction_num = 1<\/em> pour la moyenne, et options = 5<\/em> pour exclure les valeurs masqu\u00e9es et les erreurs.<\/p>\n
    Applications Pratiques<\/h2>\n
    Voici quelques sc\u00e9narios pratiques o\u00f9 cette fonction peut s’av\u00e9rer extr\u00eamement utile:<\/p>\n
    Traitement des Donn\u00e9es avec des Erreurs<\/h2>\n
    Supposons que vous g\u00e9rez une grande base de donn\u00e9es qui inclut parfois des erreurs de calcul ou des valeurs nulles mal interpr\u00e9t\u00e9es. Pour obtenir la somme tout en omettant ces erreurs :<\/p>\n
    =AGREGAT(9, 6, B2:B100)<\/code><\/pre>\n
    Cette formule r\u00e9alise une somme (utilisant 9 pour SOMME) et ignore les cellules avec erreurs (options = 6<\/em>) dans la plage B2:B100.<\/p>\n
    Filtrage des Entr\u00e9es lors d’un Reporting<\/h2>\n
    Lors de l’\u00e9laboration de rapports, vous devez parfois calculer des statistiques tout en omettant les lignes masqu\u00e9es par des filtres. Pour calculer la m\u00e9diane des ventes sans tenir compte des lignes filtr\u00e9es, vous pouvez utiliser :<\/p>\n
    =AGREGAT(12, 5, D2:D50)<\/code><\/pre>\n
    Cette formule emploie le num\u00e9ro 12 pour la m\u00e9diane et exclut les lignes masqu\u00e9es (options = 5) dans la plage D2:D50.<\/p>\n
    En r\u00e9sum\u00e9, la fonction AGREGAT est un outil essentiel dans Excel pour traiter des ensembles de donn\u00e9es complexes, particuli\u00e8rement lorsque l’exclusion de certaines valeurs est n\u00e9cessaire lors des calculs.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie un sous-total dans une liste ou une base de donn\u00e9es<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[310],"tags":[],"class_list":["post-6383","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction AGGREGATE (AGREGAT) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction AGGREGATE (AGREGAT) 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\/aggregate\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction AGGREGATE (AGREGAT) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction AGGREGATE (AGREGAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/aggregate\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:01:42+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction AGGREGATE (AGREGAT) 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\/aggregate\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/aggregate\/\",\"name\":\"Fonction AGGREGATE (AGREGAT) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:01:42+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction AGGREGATE (AGREGAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/aggregate\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/aggregate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/aggregate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math\u00e9matiques et trigonom\u00e9trie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"AGREGAT\"}]},{\"@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 AGGREGATE (AGREGAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction AGGREGATE (AGREGAT) 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\/aggregate\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction AGGREGATE (AGREGAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction AGGREGATE (AGREGAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/aggregate\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:01:42+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction AGGREGATE (AGREGAT) 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\/aggregate\/","url":"https:\/\/functiontranslator.com\/fr\/aggregate\/","name":"Fonction AGGREGATE (AGREGAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:01:42+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction AGGREGATE (AGREGAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/aggregate\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/aggregate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/aggregate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Math\u00e9matiques et trigonom\u00e9trie","item":"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"AGREGAT"}]},{"@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\/6383","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=6383"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6383\/revisions"}],"predecessor-version":[{"id":29396,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6383\/revisions\/29396"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}