{"id":3056,"date":"2023-11-17T04:34:59","date_gmt":"2023-11-17T04:34:59","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/"},"modified":"2023-12-03T11:20:54","modified_gmt":"2023-12-03T11:20:54","slug":"fugen-sie-nur-sichtbare-zellen-hinzu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/","title":{"rendered":"Wie f\u00fcge ich gefilterte zellen in excel hinzu?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-758972729\"><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>Um Werte nur aus sichtbaren Zellen in Excel zu summieren (d. h. wenn Sie einen Filter angewendet haben), m\u00fcssen Sie die Funktion ZWISCHENSUMME verwenden. Mit dieser Funktion k\u00f6nnen Sie sich auf den gesamten Bereich beziehen, sobald Sie jedoch einen Filter anwenden, arbeitet sie dynamisch und zeigt die Summe nur f\u00fcr sichtbare Zellen an.<\/p><p> Im folgenden Beispiel haben wir eine Liste von Werten in der Spalte und ich m\u00f6chte eine Formel erstellen, die mir jedes Mal die Summe anzeigen kann, wenn ich einen Filter auf die Spalte anwende. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67630\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"Liste von Werten\" width=\"429\" height=\"404\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Verwenden Sie ZWISCHENSUMME, um nur Filterzellen zu summieren<\/h2><ol type=\"1\"><li> Geben Sie zun\u00e4chst in Zelle B1 die Funktion ZWISCHENSUMME ein.<\/li><li> Geben Sie anschlie\u00dfend im ersten Argument 9 oder 109 ein.<\/li><li> Geben Sie dann im zweiten Argument den Bereich in Spalte A an, in dem Sie die Zahl haben.<\/li><li> Geben Sie am Ende die schlie\u00dfenden Klammern ein und dr\u00fccken Sie die Eingabetaste. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67631\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sous-total-a-sommer.png\" sizes=\"auto, \" srcset=\"\" alt=\"Zwischensumme zur Summe\" width=\"871\" height=\"261\"><\/figure><\/div><p> Im folgenden Schnappschuss habe ich den Filter noch nicht angewendet und er zeigt die Summe aller Werte, die ich im Bereich habe. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67632\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-resultat-de-sous-total.png\" sizes=\"auto, \" srcset=\"\" alt=\"Zwischensummenergebnis\" width=\"489\" height=\"277\"><\/figure><\/div><p> Um diese Funktion zu testen, k\u00f6nnen Sie nun <a href=\"https:\/\/exceladvisor.org\/de\/filter-1\/\" data-wpil=\"url\">einen Filter hinzuf\u00fcgen und anwenden<\/a> . Ich werde also 1, 2 und 3 aus dem Filter ausw\u00e4hlen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67633\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ajouter-un-filtre.png\" sizes=\"auto, \" srcset=\"\" alt=\"Filter hinzuf\u00fcgen\" width=\"519\" height=\"453\"><\/figure><\/div><p> Und sobald ich die Eingabetaste dr\u00fccke, wird die Summe nur f\u00fcr die gefilterten Zellen angezeigt (sichtbar). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67634\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-somme-des-valeurs-filtrees.png\" sizes=\"auto, \" srcset=\"\" alt=\"Summe der gefilterten Werte\" width=\"505\" height=\"252\"><\/figure><\/div><p> Jetzt ist diese Funktion dynamisch und sobald Sie den Filter \u00e4ndern, \u00e4ndert sich der Ergebniswert abh\u00e4ngig von den sichtbaren Zellen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67635\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-fonction-de-sous-total-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"dynamische Zwischensummenfunktion\" width=\"522\" height=\"355\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBTOTAL(9,A2:A1001)<\/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\/11\/additionner-les-cellules-visibles.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-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-3056","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 gefilterte Zellen in Excel hinzu?<\/title>\n<meta name=\"description\" content=\"In diesem Formel-Tutorial erfahren Sie, wie Sie nur die sichtbaren Zellen, also die gefilterten Zellen, 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\/fugen-sie-nur-sichtbare-zellen-hinzu\/\" \/>\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 gefilterte Zellen in Excel hinzu?\" \/>\n<meta property=\"og:description\" content=\"In diesem Formel-Tutorial erfahren Sie, wie Sie nur die sichtbaren Zellen, also die gefilterten Zellen, hinzuf\u00fcgen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:20:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.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\/fugen-sie-nur-sichtbare-zellen-hinzu\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/\",\"name\":\"\u25b7 Wie f\u00fcge ich gefilterte Zellen in Excel hinzu?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\",\"datePublished\":\"2023-11-17T04:34:59+00:00\",\"dateModified\":\"2023-12-03T11:20:54+00:00\",\"description\":\"In diesem Formel-Tutorial erfahren Sie, wie Sie nur die sichtbaren Zellen, also die gefilterten Zellen, hinzuf\u00fcgen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie f\u00fcge ich gefilterte zellen 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 gefilterte Zellen in Excel hinzu?","description":"In diesem Formel-Tutorial erfahren Sie, wie Sie nur die sichtbaren Zellen, also die gefilterten Zellen, 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\/fugen-sie-nur-sichtbare-zellen-hinzu\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie f\u00fcge ich gefilterte Zellen in Excel hinzu?","og_description":"In diesem Formel-Tutorial erfahren Sie, wie Sie nur die sichtbaren Zellen, also die gefilterten Zellen, hinzuf\u00fcgen.","og_url":"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:20:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.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\/fugen-sie-nur-sichtbare-zellen-hinzu\/","url":"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/","name":"\u25b7 Wie f\u00fcge ich gefilterte Zellen in Excel hinzu?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png","datePublished":"2023-11-17T04:34:59+00:00","dateModified":"2023-12-03T11:20:54+00:00","description":"In diesem Formel-Tutorial erfahren Sie, wie Sie nur die sichtbaren Zellen, also die gefilterten Zellen, hinzuf\u00fcgen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-nur-sichtbare-zellen-hinzu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie f\u00fcge ich gefilterte zellen 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\/3056","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=3056"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3056\/revisions"}],"predecessor-version":[{"id":4034,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3056\/revisions\/4034"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}