{"id":3227,"date":"2023-11-08T20:34:39","date_gmt":"2023-11-08T20:34:39","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/"},"modified":"2023-12-03T11:21:26","modified_gmt":"2023-12-03T11:21:26","slug":"summe-falls-enthalten","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/","title":{"rendered":"Wie f\u00fcge ich zellen mit bestimmtem text hinzu?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-4170356113\"><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 die Werte von Zellen zu summieren, in denen Sie bestimmten Text oder Teiltext haben, m\u00fcssen Sie <a href=\"https:\/\/exceladvisor.org\/de\/platzhalter-2\/\" data-wpil=\"url\">Platzhalter<\/a> mit SUMIF verwenden. Im Kriteriumsargument m\u00fcssen Sie vor und nach dem Text ein Sternchen mit einem kaufm\u00e4nnischen Und verwenden, so wie wir es im folgenden Beispiel verwendet haben, um die Zellen zu addieren, in denen Sie in der Spalte \u201eProdukt\u201c den Text \u201eMobile\u201c haben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77808\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Sumif-Teiltext\" width=\"597\" height=\"298\"><\/figure><\/div><p> In diesem Tutorial lernen wir, wie man diese Formel mit SUMIF schreibt.<\/p><h2 class=\"wp-block-heading\"> Formel zum Hinzuf\u00fcgen, WENN die Zelle bestimmten Text enth\u00e4lt<\/h2><ol><li> Geben Sie zun\u00e4chst in Zelle C1 \u201e=SUMIF(\u201c ein.<\/li><li> Danach beziehen wir uns auf den Bereich, aus dem wir die Kriterien \u00fcberpr\u00fcfen m\u00fcssen.<\/li><li> Geben Sie nun in den Kriterien asterisk-criteria-asterisk (\u201e*\u201c&amp;\u201cMobile\u201c&amp;\u201c*\u201c) ein.<\/li><li> Verweisen Sie dann im Argument sum_range auf die Mengenspalte.<\/li><li> Dr\u00fccken Sie am Ende 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-77809\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-comprendre-sumif-contient-une-formule-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"Verstehe, dass Sumif Textformeln enth\u00e4lt\" width=\"604\" height=\"140\"><\/figure><\/div><p class=\"formula\"> =SUMIF(A2:A10\u201c,*\u201c&amp;\u201cMobil\u201c&amp;\u201c*\u201c,B2:B10) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77810\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-sumif-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"Sumif-Referenz\" width=\"609\" height=\"468\"><\/figure><\/div><div class=\"gb-container gb-container-ad6b2fd6 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-ae10a664 gb-headline-text gb-headline-4f7959c2\"> Holen Sie sich die Excel-Datei<\/h2><p> <a class=\"gb-button gb-button-bd7e9e60 gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/sumif-contient-du-texte.xlsx\" rel=\"nofollow\">Herunterladen<\/a><\/p><\/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 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-3227","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 Zellen mit bestimmtem Text hinzu?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie Werte hinzuf\u00fcgen, wenn eine Zelle bestimmten Text enth\u00e4lt. Hierf\u00fcr k\u00f6nnen Sie verwenden\" \/>\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-falls-enthalten\/\" \/>\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 Zellen mit bestimmtem Text hinzu?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie Werte hinzuf\u00fcgen, wenn eine Zelle bestimmten Text enth\u00e4lt. Hierf\u00fcr k\u00f6nnen Sie verwenden\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:21:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.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-falls-enthalten\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/\",\"name\":\"\u25b7 Wie f\u00fcge ich Zellen mit bestimmtem Text hinzu?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png\",\"datePublished\":\"2023-11-08T20:34:39+00:00\",\"dateModified\":\"2023-12-03T11:21:26+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie Werte hinzuf\u00fcgen, wenn eine Zelle bestimmten Text enth\u00e4lt. Hierf\u00fcr k\u00f6nnen Sie verwenden\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie f\u00fcge ich zellen mit bestimmtem text 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 Zellen mit bestimmtem Text hinzu?","description":"In diesem Tutorial erfahren Sie, wie Sie Werte hinzuf\u00fcgen, wenn eine Zelle bestimmten Text enth\u00e4lt. Hierf\u00fcr k\u00f6nnen Sie verwenden","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-falls-enthalten\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie f\u00fcge ich Zellen mit bestimmtem Text hinzu?","og_description":"In diesem Tutorial erfahren Sie, wie Sie Werte hinzuf\u00fcgen, wenn eine Zelle bestimmten Text enth\u00e4lt. Hierf\u00fcr k\u00f6nnen Sie verwenden","og_url":"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:21:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.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-falls-enthalten\/","url":"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/","name":"\u25b7 Wie f\u00fcge ich Zellen mit bestimmtem Text hinzu?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png","datePublished":"2023-11-08T20:34:39+00:00","dateModified":"2023-12-03T11:21:26+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie Werte hinzuf\u00fcgen, wenn eine Zelle bestimmten Text enth\u00e4lt. Hierf\u00fcr k\u00f6nnen Sie verwenden","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/summe-falls-enthalten\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie f\u00fcge ich zellen mit bestimmtem text 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\/3227","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=3227"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3227\/revisions"}],"predecessor-version":[{"id":4064,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3227\/revisions\/4064"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}