{"id":3288,"date":"2023-11-04T03:45:08","date_gmt":"2023-11-04T03:45:08","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/"},"modified":"2023-12-03T11:21:22","modified_gmt":"2023-12-03T11:21:22","slug":"summe-pro-gruppe-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/","title":{"rendered":"Wie f\u00fcge ich werte nach gruppen in excel hinzu?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-3709581506\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Nehmen wir an, Sie haben eine Liste von Gruppen mit der Anzahl der Personen, denen die Gruppe angeh\u00f6rt. Jetzt m\u00fcssen Sie eine Formel schreiben, um die Summe durch die Gruppe zu berechnen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83706\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-par-groupe.png\" sizes=\"auto, \" srcset=\"\" alt=\"Summenwerte pro Gruppe\" width=\"644\" height=\"419\"><\/figure><\/div><p> Hierf\u00fcr k\u00f6nnen Sie SUMIF oder SWUMIFS verwenden.<\/p><h2 class=\"wp-block-heading\"> Formel zum Addieren von Werten nach Gruppen<\/h2><ol type=\"1\"><li> Geben Sie SUMIF in eine Zelle ein.<\/li><li> Sehen Sie sich den Bereich (B2:B13) an, in dem Sie die Gruppennamen haben.<\/li><li> Geben Sie den Gruppennamen an oder verweisen Sie auf die Zelle, in der Sie die zu benennende Gruppe haben.<\/li><li> Beziehen Sie sich auf den Bereich (C2:C13), um die Werte hinzuzuf\u00fcgen.<\/li><li> Schlie\u00dfen Sie die Funktion und dr\u00fccken Sie die Eingabetaste, um das Ergebnis zu erhalten. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83707\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sumif-pour-additionner-les-valeurs-par-groupe.png\" sizes=\"auto, \" srcset=\"\" alt=\"Sumif-to-Summe-Werte nach Gruppe\" width=\"670\" height=\"298\"><\/figure><\/div><p> Sobald Sie die Eingabetaste dr\u00fccken, wird die Summe der Nordgruppe in der Zelle zur\u00fcckgegeben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83708\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-des-valeurs-du-groupe-refere.png\" sizes=\"auto, \" srcset=\"\" alt=\"Summe der Werte der genannten Gruppe\" width=\"506\" height=\"247\"><\/figure><\/div><p> Und Sie k\u00f6nnen die Formel auf alle Gruppen ziehen, um die Summe zu erhalten. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83709\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-faites-glisser-la-formule-vers-tous-les-groupes.png\" sizes=\"auto, \" srcset=\"\" alt=\"Drag-Formel-in-alle-Gruppen\" width=\"635\" height=\"416\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(B2:B13,E3,C2:C13)<\/code><\/pre><h2 class=\"wp-block-heading\"> Summe nach mehreren Gruppen<\/h2><p> Im folgenden Beispiel haben wir zwei Gruppen mit zwei unterschiedlichen Spalten. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83710\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-somme-par-plusieurs-groupes.png\" sizes=\"auto, \" srcset=\"\" alt=\"Summe durch mehrere Gruppen\" width=\"733\" height=\"407\"><\/figure><\/div><p> Um Werte basierend auf zwei Gruppen hinzuzuf\u00fcgen, m\u00fcssen Sie SUMIFS anstelle von SUMIF verwenden. Im ersten Kriterium haben wir Gruppe 1 (Region) verwendet; im zweiten haben wir Gruppe 2 (Geschlecht) verwendet. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83711\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-sumifs-pour-additionner-les-valeurs-de-deux-groupes.png\" sizes=\"auto, \" srcset=\"\" alt=\"Sumifs-zu-Summenwerte-von-zwei-Gruppen\" width=\"486\" height=\"164\"><\/figure><\/div><p> B2:B13 ist die Spalte von Gruppe 1 und C2:C13 ist die von Gruppe 2.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIFS(D2:D13,B2:B13,F3,C2:C13,G2)<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Holen Sie sich die Excel-Datei<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-par-groupe.xlsx\" rel=\"nofollow\">Herunterladen<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/formeln\/\">Liste der Excel-Formeln<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Verwandte Formeln <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als\/\">Summe gr\u00f6\u00dfer als Werte mit SUMIF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/summen-nicht-gleich\/\">Summe ungleicher Werte (SUMIFS) in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/sumif-sumifs-oder-logik\/\">SUMIF\/SUMIFS mit ODER-Logik in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/sumif-mit-platzhaltern\/\">SUMIF mit Platzhaltern in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/summe-der-werte-zwischen-zwei-daten\/\">SUMIFS-Datumsbereich (Summe der Werte zwischen zwei Datumsfeldern)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3288","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Wie f\u00fcge ich Werte nach Gruppen in Excel hinzu?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um Werte nach Gruppen hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Wie f\u00fcge ich Werte nach Gruppen in Excel hinzu?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um Werte nach Gruppen hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:21:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-par-groupe.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/\",\"name\":\"\u25b7 Wie f\u00fcge ich Werte nach Gruppen in Excel hinzu?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-par-groupe.png\",\"datePublished\":\"2023-11-04T03:45:08+00:00\",\"dateModified\":\"2023-12-03T11:21:22+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um Werte nach Gruppen hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-par-groupe.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-par-groupe.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie f\u00fcge ich werte nach gruppen in excel hinzu?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Wie f\u00fcge ich Werte nach Gruppen in Excel hinzu?","description":"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um Werte nach Gruppen hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","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:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie f\u00fcge ich Werte nach Gruppen in Excel hinzu?","og_description":"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um Werte nach Gruppen hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","og_url":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:21:22+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-par-groupe.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/","url":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/","name":"\u25b7 Wie f\u00fcge ich Werte nach Gruppen in Excel hinzu?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-par-groupe.png","datePublished":"2023-11-04T03:45:08+00:00","dateModified":"2023-12-03T11:21:22+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um Werte nach Gruppen hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-par-groupe.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-par-groupe.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/summe-pro-gruppe-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie f\u00fcge ich werte nach gruppen in excel hinzu?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3288"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3288\/revisions"}],"predecessor-version":[{"id":4060,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3288\/revisions\/4060"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}