{"id":3637,"date":"2023-09-28T22:49:35","date_gmt":"2023-09-28T22:49:35","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/summe-1\/"},"modified":"2023-12-03T13:05:13","modified_gmt":"2023-12-03T13:05:13","slug":"summe-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/summe-1\/","title":{"rendered":"Wie verwende ich sum in excel \u00fcber vba?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-2791693755\"><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>In Excel k\u00f6nnen Sie mit VBA die Summe der Werte aus einem Zellbereich oder mehreren Bereichen berechnen. Und in diesem Tutorial lernen wir die verschiedenen M\u00f6glichkeiten kennen, wie wir es verwenden k\u00f6nnen.<\/p><h2 class=\"wp-block-heading\"> Summieren Sie in VBA mit WorksheetFunction<\/h2><p> In VBA <a href=\"https:\/\/exceladvisor.org\/de\/funktionen\/\">gibt es mehrere Funktionen<\/a> , die Sie verwenden k\u00f6nnen, es gibt jedoch keine spezielle Funktion f\u00fcr diesen Zweck. Das bedeutet nicht, dass wir keine Summe bilden k\u00f6nnen. In VBA gibt es eine Eigenschaft namens <a href=\"https:\/\/exceladvisor.org\/de\/tabellenkalkulationsfunktion\/\">WorksheetFunction<\/a> , die Ihnen beim Aufrufen von Funktionen im VBA-Code helfen kann. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61238\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"Summe-in-VBA-mit-Tabelle\" width=\"463\" height=\"300\"><\/figure><\/div><p> Betrachten Sie die Summe der Werte im Bereich A1:A10.<\/p><ol><li> Geben Sie zun\u00e4chst die Arbeitsblattfunktionseigenschaft ein und w\u00e4hlen Sie dann die SUMME-Funktion aus der Liste aus. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-Arbeitsblatt-Eingabefunktion\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-entrez-la-fonction-de-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-worksheet-function\" width=\"492\" height=\"298\"><\/li><li> Als n\u00e4chstes m\u00fcssen Sie eine Anfangsklammer eingeben, wie Sie es auch tun, wenn Sie eine Funktion in die Tabellenkalkulation eingeben. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-Start-Klammer\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-parentheses-ouvrantes.png\" sizes=\"auto, \" srcset=\"\" alt=\"starting-parenthesis\" width=\"454\" height=\"285\"><\/li><li> Danach m\u00fcssen wir das <a href=\"https:\/\/exceladvisor.org\/de\/bereich-1\/\">Bereichsobjekt<\/a> verwenden, um auf den Bereich zu verweisen, f\u00fcr den wir die Summe berechnen m\u00f6chten. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-use-the-range-object\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-lobjet-range.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-the-range-object\" width=\"515\" height=\"249\"><\/li><li> Geben Sie am Ende eine schlie\u00dfende Klammer ein und weisen Sie Zelle B1 den R\u00fcckgabewert der Funktion zu. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 schlie\u00dfende Klammern\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-parenthese-fermante.png\" sizes=\"auto, \" srcset=\"\" alt=\"closing-parenthesis\" width=\"653\" height=\"229\"><\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Range<\/strong> (\"B1\") = Application.WorksheetFunction.Sum(Range(\"A1:A10\"))<\/code><\/pre><p> Wenn Sie nun diesen Code ausf\u00fchren, berechnet er die Summe der Werte im Bereich A1:A10 und <a href=\"https:\/\/exceladvisor.org\/de\/zellenwert\/\">gibt den Wert in Zelle<\/a> B1 ein. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61243\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-executer-le-code-pour-calculer.png\" sizes=\"auto, \" srcset=\"\" alt=\"F\u00fchren Sie den Code aus, um ihn zu berechnen\" width=\"722\" height=\"346\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Summe der Werte einer gesamten Spalte oder Zeile<\/h2><p> Geben Sie in diesem Fall einfach eine Zeile oder Spalte anstelle des Bereichs an, den wir im vorherigen Beispiel verwendet haben.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">' <strong>for<\/strong> the entire column A <strong>Range<\/strong> (\"B1\") = Application.WorksheetFunction.Sum( <strong>Range<\/strong> (\"A:A\")) ' <strong>for<\/strong> entire row 1 <strong>Range<\/strong> (\"B1\") = Application.WorksheetFunction.Sum( <strong>Range<\/strong> (\"1:1\"))<\/code><\/pre><h2 class=\"wp-block-heading\"> Verwenden Sie VBA, um Auswahlwerte hinzuzuf\u00fcgen<\/h2><p> Angenommen, Sie m\u00f6chten nur den Wert der ausgew\u00e4hlten Zellen summieren, da Sie Code wie diesen verwenden k\u00f6nnen.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_sum_selection() <strong>Dim<\/strong> sRange <strong>As<\/strong> Range <strong>Dim<\/strong> iSum <strong>As<\/strong> Long <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler <strong>Set<\/strong> sRange = Selection iSum = WorksheetFunction.Sum(Range(sRange.Address)) MsgBox iSum errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><p> Im obigen Code haben wir die Auswahl verwendet, sie dann in der Variablen \u201esRange\u201c angegeben und dann die Adresse dieser Bereichsvariablen verwendet, um die Summe zu erhalten.<\/p><h2 class=\"wp-block-heading\"> VBA-Summe aller Zellen oben<\/h2><p> Der folgende Code extrahiert alle Zellen und Summenwerte und tr\u00e4gt das Ergebnis in die ausgew\u00e4hlte Zelle ein.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_auto_sum() <strong>Dim<\/strong> iFirst <strong>As<\/strong> String <strong>Dim<\/strong> iLast <strong>As<\/strong> String <strong>Dim<\/strong> iRange <strong>As<\/strong> Range <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler iFirst = Selection. <strong>End<\/strong> (xlUp). <strong>End<\/strong> (xlUp).Address iLast = Selection. <strong>End<\/strong> (xlUp).Address <strong>Set<\/strong> iRange = Range(iFirst &amp; \":\" &amp; iLast) ActiveCell = WorksheetFunction.Sum(iRange) <strong>Exit<\/strong> <strong>Sub<\/strong> errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><h2 class=\"wp-block-heading\"> F\u00fcgen Sie mit VBA einen dynamischen Bereich hinzu<\/h2><p> Und \u00e4hnlich k\u00f6nnen Sie den Dynamikbereich nutzen, w\u00e4hrend Sie VBA zum Hinzuf\u00fcgen von Werten verwenden.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_dynamic_range_sum() <strong>Dim<\/strong> iFirst <strong>As<\/strong> String <strong>Dim<\/strong> iLast <strong>As<\/strong> String <strong>Dim<\/strong> iRange <strong>As<\/strong> Range <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler iFirst = Selection.Offset(1, 1).Address iLast = Selection.Offset(5, 5).Address <strong>Set<\/strong> iRange = Range(iFirst &amp; \":\" &amp; iLast) ActiveCell = WorksheetFunction.Sum(iRange) <strong>Exit<\/strong> <strong>Sub<\/strong> errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><h2 class=\"wp-block-heading\"> F\u00fcgen Sie eine dynamische Spalte oder Zeile hinzu<\/h2><p> Wenn Sie eine dynamische Spalte verwenden m\u00f6chten, k\u00f6nnen Sie auf \u00e4hnliche Weise den folgenden Code verwenden, der die Spalte der aktiven Zelle nimmt und alle dort vorhandenen Werte addiert.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_dynamic_column() <strong>Dim<\/strong> iCol <strong>As<\/strong> Long <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler iCol = ActiveCell.Column MsgBox WorksheetFunction.Sum(Columns(iCol)) <strong>Exit<\/strong> <strong>Sub<\/strong> errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><p> Und zwar f\u00fcr eine Reihe.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_dynamic_row() <strong>Dim<\/strong> iRow <strong>As<\/strong> Long <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler iRow = ActiveCell.Row MsgBox WorksheetFunction.Sum(Rows(iCol)) <strong>Exit<\/strong> <strong>Sub<\/strong> errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><h2 class=\"wp-block-heading\"> Verwenden Sie SUMIF mit VBA<\/h2><p> Genau wie sum k\u00f6nnen Sie die SUMIF-Funktion verwenden, um Werte mit Kriterien wie im folgenden Beispiel hinzuzuf\u00fcgen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61244\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-sumif-avec-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-mit-vba\" width=\"771\" height=\"332\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_sumif() Dim cRange <strong>As<\/strong> <strong>Range<\/strong> Dim sRange <strong>As<\/strong> <strong>Range<\/strong> <strong>Set<\/strong> cRange = <strong>Range<\/strong> (\"A2:A13\") <strong>Set<\/strong> sRange = <strong>Range<\/strong> (\"B2:B13\") <strong>Range<\/strong> (\"C2\") = _ WorksheetFunction.SumIf(cRange, \"Product B\", sRange) End Sub<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/vba\/\">Was ist VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Verwandte Tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/durchschnitt-2\/\">Durchschnittswerte in Excel mit VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/heutiges-datum-aktuelle-uhrzeit\/\">Erhalten Sie das heutige Datum und die aktuelle Uhrzeit mit VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/spiel-2\/\">Match-Funktion in VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/modus-1\/\">MOD in VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/zufallszahl\/\">VBA-Zufallszahlen<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-3637","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 verwende ich SUM in Excel \u00fcber VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie mit VBA Werte aus einer Reihe von Zellen und Spalten in Excel hinzuf\u00fcgen\" \/>\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-1\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie verwende ich SUM in Excel \u00fcber VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie mit VBA Werte aus einer Reihe von Zellen und Spalten in Excel hinzuf\u00fcgen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/summe-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:05:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.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=\"4\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-1\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/summe-1\/\",\"name\":\"Wie verwende ich SUM in Excel \u00fcber VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png\",\"datePublished\":\"2023-09-28T22:49:35+00:00\",\"dateModified\":\"2023-12-03T13:05:13+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie mit VBA Werte aus einer Reihe von Zellen und Spalten in Excel hinzuf\u00fcgen\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-1\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/summe-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich sum in excel \u00fcber vba?\"}]},{\"@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 verwende ich SUM in Excel \u00fcber VBA? (Tutorial 2023)","description":"In diesem Tutorial erfahren Sie, wie Sie mit VBA Werte aus einer Reihe von Zellen und Spalten in Excel hinzuf\u00fcgen","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-1\/","og_locale":"de_DE","og_type":"article","og_title":"Wie verwende ich SUM in Excel \u00fcber VBA? (Tutorial 2023)","og_description":"In diesem Tutorial erfahren Sie, wie Sie mit VBA Werte aus einer Reihe von Zellen und Spalten in Excel hinzuf\u00fcgen","og_url":"https:\/\/exceladvisor.org\/de\/summe-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:05:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"4\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/summe-1\/","url":"https:\/\/exceladvisor.org\/de\/summe-1\/","name":"Wie verwende ich SUM in Excel \u00fcber VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/summe-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/summe-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png","datePublished":"2023-09-28T22:49:35+00:00","dateModified":"2023-12-03T13:05:13+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie mit VBA Werte aus einer Reihe von Zellen und Spalten in Excel hinzuf\u00fcgen","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/summe-1\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/summe-1\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/summe-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/summe-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich sum in excel \u00fcber vba?"}]},{"@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\/3637","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=3637"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3637\/revisions"}],"predecessor-version":[{"id":4381,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3637\/revisions\/4381"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}