{"id":6790,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction-ens\/"},"modified":"2021-02-26T08:14:24","modified_gmt":"2021-02-26T08:14:24","slug":"sumifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/sumifs\/","title":{"rendered":"ens"},"content":{"rendered":"

Description et Syntaxe<\/h2>\n

La fonction SUMIFS dans Microsoft Excel et Google Sheets est con\u00e7ue pour calculer la somme d’une s\u00e9rie de donn\u00e9es selon plusieurs crit\u00e8res sp\u00e9cifiques. Cette fonction est extr\u00eamement utile pour l’analyse d\u00e9taill\u00e9e de vastes ensembles de donn\u00e9es, permettant de filtrer et d’agr\u00e9ger des totaux partiels selon des conditions pr\u00e9d\u00e9finies.<\/p>\n

Syntaxe g\u00e9n\u00e9rale pour Excel :<\/p>\n

SUMIFS(somme_plage, plage_crit\u00e8res1, crit\u00e8res1, [plage_crit\u00e8res2, crit\u00e8res2], ...)<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • somme_plage<\/b> : La plage de cellules dont vous souhaitez calculer la somme.<\/li>\n
  • plage_crit\u00e8res1<\/b>, plage_crit\u00e8res2<\/b>, … : Les plages dans lesquelles les crit\u00e8res sp\u00e9cifi\u00e9s seront \u00e9valu\u00e9s.<\/li>\n
  • crit\u00e8res1<\/b>, crit\u00e8res2<\/b>, … : Les conditions que les cellules des plages de crit\u00e8res doivent remplir pour \u00eatre incluses dans la somme.<\/li>\n<\/ul>\n
    Exemple simple :<\/p>\n
    =SUMIFS(A1:A10, B1:B10, \">20\", C1:C10, \"<>absent\")<\/code><\/pre>\n
    Cette formule additionne les valeurs de la plage A1 \u00e0 A10 o\u00f9 les cellules correspondantes dans B1 \u00e0 B10 sont sup\u00e9rieures \u00e0 20 et celles dans C1 \u00e0 C10 ne contiennent pas la mention \u00ab\u00a0absent\u00a0\u00bb.<\/p>\n
    Applications pratiques<\/h2>\n
    Exemple 1 : Suivi des d\u00e9penses<\/h2>\n
    Consid\u00e9rez une liste de d\u00e9penses et vous souhaitez en conna\u00eetre la somme pour certaines cat\u00e9gories et montants d\u00e9passant un seuil donn\u00e9.<\/p>\n\n\n\n\n\n
    Date<\/b><\/td>\nCat\u00e9gorie<\/b><\/td>\nMontant<\/b><\/td>\n<\/tr>\n
    2023-01-01<\/td>\nAlimentation<\/td>\n45<\/td>\n<\/tr>\n
    2023-01-02<\/td>\nTransport<\/td>\n30<\/td>\n<\/tr>\n
    2023-01-03<\/td>\nAlimentation<\/td>\n20<\/td>\n<\/tr>\n<\/table>\n
    Formule \u00e0 utiliser :<\/p>\n
    =SUMIFS(C2:C4, B2:B4, \"Alimentation\", C2:C4, \">25\")<\/code><\/pre>\n
    Cette formule totalisera les montants de la colonne C (Montant) o\u00f9 les entr\u00e9es dans la colonne B (Cat\u00e9gorie) correspondent \u00e0 \u00ab\u00a0Alimentation\u00a0\u00bb et que les montants sont sup\u00e9rieurs \u00e0 25. Le total obtenu sera de 45.<\/p>\n
    Exemple 2 : Calcul des bonus de l’\u00e9quipe<\/h2>\n
    Dans le sch\u00e9ma o\u00f9 une entreprise d\u00e9sire r\u00e9compenser ses employ\u00e9s avec des bonus bas\u00e9s sur plusieurs crit\u00e8res tels que le d\u00e9partement et la performance.<\/p>\n\n\n\n\n\n
    Nom<\/b><\/td>\nD\u00e9partement<\/b><\/td>\nTaux de r\u00e9alisation<\/b><\/td>\nBonus potentiel<\/b><\/td>\n<\/tr>\n
    Jean<\/td>\nVentes<\/td>\n110%<\/td>\n1000<\/td>\n<\/tr>\n
    Marie<\/td>\nMarketing<\/td>\n105%<\/td>\n900<\/td>\n<\/tr>\n
    Pierre<\/td>\nVentes<\/td>\n103%<\/td>\n850<\/td>\n<\/tr>\n<\/table>\n
    Formule \u00e0 utiliser :<\/p>\n
    =SUMIFS(D2:D4, B2:B4, \"Ventes\", C2:C4, \">=105%\")<\/code><\/pre>\n
    Dans cet exemple, la somme des bonus est calcul\u00e9e pour les cellules dans la colonne D (Bonus potentiel), o\u00f9 le d\u00e9partement indiqu\u00e9 en colonne B est \u00ab\u00a0Ventes\u00a0\u00bb et le taux de r\u00e9alisation \u00e9gale ou d\u00e9passe 105%. Ici, le montant total sera 1000, car seul Jean r\u00e9pond \u00e0 ces crit\u00e8res.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Ajoute les cellules d\u2019une plAge 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":[310],"tags":[],"class_list":["post-6790","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SUMIFS (ens) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SUMIFS (ens) 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\/sumifs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SUMIFS (ens) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SUMIFS (ens) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/sumifs\/\" \/>\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:14:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SUMIFS (ens) 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\/sumifs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sumifs\/\",\"name\":\"Fonction SUMIFS (ens) 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:14:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SUMIFS (ens) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumifs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sumifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sumifs\/#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\":\"ens\"}]},{\"@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 SUMIFS (ens) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SUMIFS (ens) 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\/sumifs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SUMIFS (ens) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SUMIFS (ens) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sumifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SUMIFS (ens) 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\/sumifs\/","url":"https:\/\/functiontranslator.com\/fr\/sumifs\/","name":"Fonction SUMIFS (ens) 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:14:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SUMIFS (ens) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sumifs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sumifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sumifs\/#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":"ens"}]},{"@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\/6790","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=6790"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6790\/revisions"}],"predecessor-version":[{"id":29799,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6790\/revisions\/29799"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}