{"id":3108,"date":"2023-11-15T10:25:02","date_gmt":"2023-11-15T10:25:02","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/summe-4\/"},"modified":"2023-12-03T11:12:24","modified_gmt":"2023-12-03T11:12:24","slug":"summe-4","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/summe-4\/","title":{"rendered":"Excel-funktion: sumwenn"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1101285101\"><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> <div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"0-intro-sumif-function\" class=\"wp-block-heading\"> Einf\u00fchrung: SUMIF-Funktion<\/h2><p> Wenn Sie in Excel die SUMMEWENN-Funktion verwenden, wird die Summe der Werte zur\u00fcckgegeben, die die von Ihnen angegebene Bedingung erf\u00fcllen. Sie m\u00fcssen den Zellbereich angeben, der auf die Bedingung \u00fcberpr\u00fcft werden soll, dann einen Wert, der als Bedingung \u00fcberpr\u00fcft werden soll, und am Ende einen Bereich, aus dem die Werte summiert werden sollen. Es sind daher drei Argumente anzugeben. <\/p><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"1-syntax\" class=\"wp-block-heading\"> Syntax<\/h2><p> SUMIF(Bereich, Kriterien, [sum_range]) <\/p><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"2-arguments\" class=\"wp-block-heading\"> Argumente<\/h2><ul><li> <strong>Bereich<\/strong> : Ein Bereich von Zellen, deren Kriterien Sie \u00fcberpr\u00fcfen m\u00f6chten.<\/li><li> <strong>Kriterien<\/strong> : ein Kriterium, das eine Zahl, ein Text, ein Ausdruck, eine Zellreferenz oder eine Funktion sein kann.<\/li><li> <strong>[sum_range]<\/strong> : Ein Zellbereich mit den Werten, die Sie summieren m\u00f6chten. <\/li><\/ul><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"3-example\" class=\"wp-block-heading\"> Beispiel<\/h2><p> Im folgenden Beispiel haben wir A1:A9 als Kriterienbereich und B1:B9 als Summenbereich angegeben und anschlie\u00dfend das Kriterium in A12 angegeben, das den Wert C hat. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-Summenfunktion-Beispiel-1\" width=\"416\" height=\"469\"><\/figure><\/div><p> Sie k\u00f6nnen Kriterien auch direkt in die Funktion einf\u00fcgen. Im folgenden Beispiel haben wir einen Sternchen-Platzhalter verwendet, um ein Kriterium anzugeben, das das Alphabet \u201eS\u201c enth\u00e4lt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37334\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-Summenfunktion-Beispiel-2\" width=\"457\" height=\"488\"><\/figure><\/div><p> Und wenn Sie den Summenbereich ignorieren, erhalten Sie die Summe des Kriterienbereichs. Dies ist jedoch nur m\u00f6glich, wenn der Kriterienbereich numerische Werte hat. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-Summenfunktion-Beispiel-3\" width=\"449\" height=\"450\"><\/figure><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> Beispieldatei<\/h2><p> <em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-2.xlsx\">Laden Sie eine Beispieldatei herunter<\/a><\/em> <\/p><div class=\"wp-block-group main-page-bottom is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 id=\"4-related\" class=\"wp-block-heading\"> Weitere Tutorials<\/h2><ul><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/de\/sumif-mit-platzhaltern\/\">SUMIF mit Platzhaltern in Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/de\/summe-der-werte-zwischen-zwei-daten\/\">Summe der Werte zwischen zwei Daten in Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/de\/sumif-sumifs-oder-logik\/\">SUMIF\/SUMIFS mit ODER-Logik in Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/de\/summen-nicht-gleich\/\">Summe ungleicher Werte (SUMIFS) in Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als\/\">Summieren Sie gr\u00f6\u00dfere Werte mit SUMIF in Excel<\/a><\/li><\/ul><h2 class=\"wp-block-heading\"> Verwandte Funktionen<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/summen-2\/\">Excel-SUMME-Funktion<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/summenprodukt-2\/\">Excel-Funktion SUMMENPRODUKT<\/a><\/li><\/ul><\/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-3108","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>SUMIF-Funktion in Excel (Schnelles Excel-Tutorial)<\/title>\n<meta name=\"description\" content=\"Dieses Tutorial zeigt, wie Sie die SUMIF-Funktion von Excel verwenden, um Werte mithilfe eines Kriteriums hinzuzuf\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-4\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SUMIF-Funktion in Excel (Schnelles Excel-Tutorial)\" \/>\n<meta property=\"og:description\" content=\"Dieses Tutorial zeigt, wie Sie die SUMIF-Funktion von Excel verwenden, um Werte mithilfe eines Kriteriums hinzuzuf\u00fcgen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/summe-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:12:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.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-4\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/summe-4\/\",\"name\":\"SUMIF-Funktion in Excel (Schnelles Excel-Tutorial)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"datePublished\":\"2023-11-15T10:25:02+00:00\",\"dateModified\":\"2023-12-03T11:12:24+00:00\",\"description\":\"Dieses Tutorial zeigt, wie Sie die SUMIF-Funktion von Excel verwenden, um Werte mithilfe eines Kriteriums hinzuzuf\u00fcgen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-4\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/summe-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-4\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel-funktion: sumwenn\"}]},{\"@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":"SUMIF-Funktion in Excel (Schnelles Excel-Tutorial)","description":"Dieses Tutorial zeigt, wie Sie die SUMIF-Funktion von Excel verwenden, um Werte mithilfe eines Kriteriums hinzuzuf\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-4\/","og_locale":"de_DE","og_type":"article","og_title":"SUMIF-Funktion in Excel (Schnelles Excel-Tutorial)","og_description":"Dieses Tutorial zeigt, wie Sie die SUMIF-Funktion von Excel verwenden, um Werte mithilfe eines Kriteriums hinzuzuf\u00fcgen.","og_url":"https:\/\/exceladvisor.org\/de\/summe-4\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:12:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.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-4\/","url":"https:\/\/exceladvisor.org\/de\/summe-4\/","name":"SUMIF-Funktion in Excel (Schnelles Excel-Tutorial)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/summe-4\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/summe-4\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","datePublished":"2023-11-15T10:25:02+00:00","dateModified":"2023-12-03T11:12:24+00:00","description":"Dieses Tutorial zeigt, wie Sie die SUMIF-Funktion von Excel verwenden, um Werte mithilfe eines Kriteriums hinzuzuf\u00fcgen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/summe-4\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/summe-4\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/summe-4\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/summe-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Excel-funktion: sumwenn"}]},{"@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\/3108","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=3108"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3108\/revisions"}],"predecessor-version":[{"id":3754,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3108\/revisions\/3754"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}