{"id":6487,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bdmoyenne\/"},"modified":"2021-02-26T08:04:22","modified_gmt":"2021-02-26T08:04:22","slug":"daverage","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/daverage\/","title":{"rendered":"BDMOYENNE"},"content":{"rendered":"

La fonction DAVERAGE, appel\u00e9e BDMOYENNE en fran\u00e7ais, constitue un outil essentiel tant dans Microsoft Excel que Google Sheets. Elle sert \u00e0 calculer la moyenne des valeurs dans une colonne sp\u00e9cifique, pour les enregistrements qui satisfont des crit\u00e8res pr\u00e9cis au sein d’une table ou d’une base de donn\u00e9es.<\/p>\n

Description et Syntaxe<\/h2>\n

La syntaxe de la fonction BDMOYENNE se pr\u00e9sente comme suit :<\/p>\n

BDMOYENNE(base; champ; crit\u00e8res)<\/code><\/pre>\n
    \n
  • base :<\/strong> Correspond \u00e0 la plage de cellules constituant la base de donn\u00e9es.<\/li>\n
  • champ :<\/strong> La colonne pour laquelle la moyenne doit \u00eatre calcul\u00e9e. Le champ peut \u00eatre sp\u00e9cifi\u00e9 par son nom (entre guillemets) ou par son num\u00e9ro de position dans la base de donn\u00e9es.<\/li>\n
  • crit\u00e8res :<\/strong> La plage de cellules qui d\u00e9finit les crit\u00e8res de s\u00e9lection des enregistrements \u00e0 inclure dans le calcul.<\/li>\n<\/ul>\n
    Exemples Pratiques<\/h2>\n
    Imaginons que nous disposions d’une base de donn\u00e9es d’employ\u00e9s comprenant les colonnes : ID, Nom, D\u00e9partement, et Salaire. Nous souhaitons calculer le salaire moyen dans diff\u00e9rents contextes.<\/p>\n
    Exemple 1 : Calculer le salaire moyen du d\u00e9partement ‘Ventes’<\/strong><\/p>\n
    Voici la structure de la base de donn\u00e9es :<\/p>\n
    ID Nom D\u00e9partement Salaire 1 Alice Ventes 1200 2 Bob Marketing 1500 3 Clara Ventes 1100 4 David IT 1800<\/code><\/pre>\n
    Les crit\u00e8res sont d\u00e9finis dans une plage d\u00e9nomm\u00e9e (par exemple A7:B8) :<\/p>\n
    D\u00e9partement Ventes<\/code><\/pre>\n
    Pour trouver la moyenne des salaires dans le d\u00e9partement ‘Ventes’, nous utiliserons la formule :<\/p>\n
    =BDMOYENNE(A1:D4; \"Salaire\"; A7:B8)<\/code><\/pre>\n
    Cette formule calculera la moyenne des salaires d’Alice et de Clara, soit 1150.<\/p>\n
    Exemple 2 : Calculer le salaire moyen des employ\u00e9s gagnant plus de 1300 euros<\/strong><\/p>\n
    Les crit\u00e8res pour cet exemple sont :<\/p>\n
    Salaire >1300<\/code><\/pre>\n
    La formule applicable serait :<\/p>\n
    =BDMOYENNE(A1:D4; \"Salaire\"; A9:B10)<\/code><\/pre>\n
    Cette formule analyse les salaires de Bob et David, et retourne une moyenne de 1650.<\/p>\n
    Applications Pratiques<\/h2>\n
    La fonction BDMOYENNE trouve son utilit\u00e9 dans des contextes vari\u00e9s, notamment :<\/p>\n
      \n
    • Analyse des donn\u00e9es RH pour \u00e9valuer les structures salariales par d\u00e9partements ou par postes.<\/li>\n
    • Suivi et analyse des performances acad\u00e9miques dans les \u00e9tablissements scolaires, permettant de calculer des moyennes en fonction de divers crit\u00e8res tels que la classe ou le groupe d’\u00e2ge.<\/li>\n
    • Analyse financi\u00e8re pour \u00e9valuer les moyennes de ventes, de revenus, ou d’autres indicateurs \u00e9conomiques, filtr\u00e9es par des crit\u00e8res sp\u00e9cifiques tels que les r\u00e9gions, les p\u00e9riodes ou les cat\u00e9gories de produits.<\/li>\n<\/ul>\n
       Ce code HTML structur\u00e9 offre une explication claire ainsi que des exemples pratiques d\u00e9montrant l’utilisation efficace de la fonction BDMOYENNE dans Excel et Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la moyenne des entR\u00e9es de base de donn\u00e9es s\u00e9lectionn\u00e9es<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[322],"tags":[],"class_list":["post-6487","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"\nFonction DAVERAGE (BDMOYENNE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DAVERAGE (BDMOYENNE) 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\/daverage\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DAVERAGE (BDMOYENNE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DAVERAGE (BDMOYENNE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/daverage\/\" \/>\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:04:22+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DAVERAGE (BDMOYENNE) 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\/daverage\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/daverage\/\",\"name\":\"Fonction DAVERAGE (BDMOYENNE) 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:04:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DAVERAGE (BDMOYENNE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/daverage\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/daverage\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/daverage\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de donn\u00e9es\",\"item\":\"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BDMOYENNE\"}]},{\"@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 DAVERAGE (BDMOYENNE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DAVERAGE (BDMOYENNE) 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\/daverage\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DAVERAGE (BDMOYENNE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DAVERAGE (BDMOYENNE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/daverage\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DAVERAGE (BDMOYENNE) 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\/daverage\/","url":"https:\/\/functiontranslator.com\/fr\/daverage\/","name":"Fonction DAVERAGE (BDMOYENNE) 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:04:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DAVERAGE (BDMOYENNE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/daverage\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/daverage\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/daverage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Base de donn\u00e9es","item":"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/"},{"@type":"ListItem","position":3,"name":"BDMOYENNE"}]},{"@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\/6487","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=6487"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6487\/revisions"}],"predecessor-version":[{"id":29499,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6487\/revisions\/29499"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}