{"id":3234,"date":"2023-11-08T04:15:58","date_gmt":"2023-11-08T04:15:58","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/"},"modified":"2023-12-03T11:14:13","modified_gmt":"2023-12-03T11:14:13","slug":"die-gesamtsumme-betragt-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/","title":{"rendered":"Wie berechnet man die laufende summe in excel?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-2305555294\"><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>Wenn Sie in Excel eine laufende Summe erstellen m\u00f6chten, m\u00fcssen Sie eine eigene Spalte erstellen. Genau wie im folgenden Beispiel: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83690\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png\" sizes=\"auto, \" srcset=\"\" alt=\"Gesamtlauf\" width=\"412\" height=\"383\"><\/figure><\/div><p> In Spalte C sehen Sie, dass wir f\u00fcr jeden Monat eine laufende Summe haben. So ist beispielsweise die laufende Summe f\u00fcr M\u00e4rz die Summe der Monate Januar, Februar und M\u00e4rz.<\/p><h2 id=\"h-formula-to-create-a-running-total-in-excel\" class=\"wp-block-heading\"> Formel zum Erstellen einer laufenden Summe in Excel<\/h2><ol><li> Erstellen Sie zun\u00e4chst eine neue Spalte mit der Mengenspalte. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-Aktuelle-Summe erstellen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-creer-un-total-cumule.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-running-total\" width=\"452\" height=\"333\"><\/li><li> Geben Sie anschlie\u00dfend die Summenfunktion ein und beziehen Sie sich auf den Bereich B2:B2. <br><img loading=\"lazy\" decoding=\"async\" title=\"Summenfunktion mit 3 Eing\u00e4ngen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrer-la-fonction-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-sum-function\" width=\"451\" height=\"299\"><\/li><li> Sperren Sie nun ausgehend von der Bereichsreferenz die erste Zelle mit dem Dollarzeichen. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-Sperre-die-erste-Zelle-mit-Dollar-Zeichen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-verrouiller-la-premiere-cellule-en-utilisant-le-signe-dollar.png\" sizes=\"auto, \" srcset=\"\" alt=\"lock-the-first-cell-using-dollar-sign\" width=\"449\" height=\"313\"><\/li><li> Ziehen Sie dann die Formel in die letzte Zelle der Spalte. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-Ziehen Sie die Formel bis zur letzten Zelle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-faites-glisser-la-formule-jusqua-la-derniere-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"drag-formula-to-the-last-cell\" width=\"468\" height=\"473\"><\/li><\/ol><p> Wenn Sie diese Formel ziehen, bleibt die Startzelle des referenzierten Bereichs B2 und die letzte Zelle wird beim Ziehen weiter verschoben. Sie k\u00f6nnen also in der laufenden Summe f\u00fcr Mai sehen, dass die Referenz f\u00fcr den Bereich $B$2:B6 gilt, f\u00fcr Dezember jedoch $B$2:B13. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83695\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-signe-dollar-verrouille-la-cellule-de-reference-de-depart.png\" sizes=\"auto, \" srcset=\"\" alt=\"Das Dollarzeichen sperrt die Startreferenzzelle\" width=\"570\" height=\"515\"><\/figure><\/div><h2 id=\"h-absolute-cell-running-total\" class=\"wp-block-heading\"> Absolute kumulative Gesamtzahl der Zellen<\/h2><p> Wir haben ein Dollarzeichen verwendet, um die erste Zelle im Bereich zu sperren und sie so zu einer absoluten Zellreferenz f\u00fcr Zelle B2 zu machen. Und wenn Sie die Formel ziehen, bleibt B2 unver\u00e4ndert und die untere Zelle des Bereichs \u00e4ndert sich st\u00e4ndig. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83696\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Total-cumule-de-7-cellules-absolues.png\" sizes=\"auto, \" srcset=\"\" alt=\"absolute-total-of-cell-executable\" width=\"515\" height=\"360\"><\/figure><\/div><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\/11\/total-cumule-2.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\/fugen-sie-die-gesamte-spalte-hinzu\/\">F\u00fcgen Sie eine ganze Spalte oder Zeile in Excel hinzu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/\">Summieren Sie nur sichtbare Zellen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/\">Summe zuf\u00e4lliger Zellen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/gesamtlinie\/\">F\u00fcgen Sie in Excel eine Gesamtzeile hinzu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/autosumme-1\/\">Verwenden Sie AutoSumme schnell in Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-3234","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>Wie berechnet man die laufende Summe in Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine laufende Summe f\u00fcr Werte zu erstellen. 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\/die-gesamtsumme-betragt-1\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie berechnet man die laufende Summe in Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine laufende Summe f\u00fcr Werte zu erstellen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:14:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.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\/die-gesamtsumme-betragt-1\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/\",\"name\":\"Wie berechnet man die laufende Summe in Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png\",\"datePublished\":\"2023-11-08T04:15:58+00:00\",\"dateModified\":\"2023-12-03T11:14:13+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine laufende Summe f\u00fcr Werte zu erstellen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie berechnet man die laufende summe in excel?\"}]},{\"@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":"Wie berechnet man die laufende Summe in Excel? (Tutorial 2023)","description":"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine laufende Summe f\u00fcr Werte zu erstellen. 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\/die-gesamtsumme-betragt-1\/","og_locale":"de_DE","og_type":"article","og_title":"Wie berechnet man die laufende Summe in Excel? (Tutorial 2023)","og_description":"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine laufende Summe f\u00fcr Werte zu erstellen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","og_url":"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:14:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.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\/die-gesamtsumme-betragt-1\/","url":"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/","name":"Wie berechnet man die laufende Summe in Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png","datePublished":"2023-11-08T04:15:58+00:00","dateModified":"2023-12-03T11:14:13+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie eine Excel-Formel schreiben, um eine laufende Summe f\u00fcr Werte zu erstellen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-total-cumule.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/die-gesamtsumme-betragt-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie berechnet man die laufende summe in excel?"}]},{"@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\/3234","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=3234"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3234\/revisions"}],"predecessor-version":[{"id":3892,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3234\/revisions\/3892"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}