{"id":3159,"date":"2023-11-12T15:00:24","date_gmt":"2023-11-12T15:00:24","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/"},"modified":"2023-12-03T11:13:26","modified_gmt":"2023-12-03T11:13:26","slug":"summe-wenn-grosser-als-null-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/","title":{"rendered":"Wie addiere ich werte gr\u00f6\u00dfer als null?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-2018861955\"><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 gr\u00f6\u00dfer als Null hinzuzuf\u00fcgen, k\u00f6nnen Sie mit der SUMIF-Funktion eine Bedingung angeben. In SUMIF k\u00f6nnen Sie mit dem Kriterienargument eine Bedingung schreiben, in der Sie den Gr\u00f6\u00dfer-als-Operator verwenden und eine Null (0) eingeben k\u00f6nnen. Sie k\u00f6nnen denselben Bereich verwenden, um die Bedingungen zu testen und die Summe zu berechnen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79474\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"Summenwert gr\u00f6\u00dfer als Null\" width=\"599\" height=\"409\"><\/figure><\/div><p> Sie k\u00f6nnen auch zwei verschiedene Bereiche verwenden, einen zum Testen der Bedingung und einen zum Ermitteln der Summe.<\/p><h2 class=\"wp-block-heading\"> Schritte zum Schreiben einer Formel: SUMWENN gr\u00f6\u00dfer als Null<\/h2><p> Sie k\u00f6nnen die folgenden Schritte ausf\u00fchren:<\/p><ol type=\"1\"><li> Geben Sie zun\u00e4chst in einer Zelle die Funktion SUMMEWENN ein.<\/li><li> Sehen Sie sich anschlie\u00dfend im Kriterienbereich die Spalte \u201eVergangene Tage\u201c an.<\/li><li> Verwenden Sie dann im Kriterienargument \u201e&gt;0\u201c.<\/li><li> Beziehen Sie sich nun in sum_range auf die Spalte \u201eMenge\u201c.<\/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-79475\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-somme-si-superieur-a-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"Sumif-gr\u00f6\u00dfer-als-null\" width=\"694\" height=\"412\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(B2:B11,\"&gt;0\",C2:C11)<\/code><\/pre><p> Wie Sie sehen, wird nur die Summe der Werte in der Spalte \u201eMenge\u201c zur\u00fcckgegeben, wenn Sie in der Spalte \u201eVergangene Tage\u201c einen Wert gr\u00f6\u00dfer als Null haben. Das gleiche Ergebnis sehen Sie in der <a href=\"https:\/\/exceladvisor.org\/de\/statusleiste\/\">Statusleiste<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79476\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-renvoie-la-valeur-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"R\u00fcckgabesummenwert\" width=\"581\" height=\"396\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Verwenden eines Zellbezugs zur Angabe von Null<\/h2><p> Beim Schreiben der Formel k\u00f6nnen Sie auf eine Zelle verweisen, um darin Null anzugeben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79477\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Reference-de-4-cellules-pour-specifier-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"Zellreferenz zur Angabe von Null\" width=\"673\" height=\"374\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(B2:B11,\"&gt;\"&amp;D1,C2:C11)<\/code><\/pre><p> In der obigen Formel haben wir in den Kriterien ein kaufm\u00e4nnisches Und verwendet und dann auf Zelle D1 verwiesen, in der wir die Null haben. Dies f\u00fchrt zu einer dynamischen Formel, in der Sie den Zustand der Zelle \u00e4ndern k\u00f6nnen, anstatt ihn in der Formel zu \u00e4ndern.<\/p><h2 class=\"wp-block-heading\"> Was ist, wenn ich SUMIFS anstelle von SUMIF verwenden m\u00f6chte?<\/h2><p> Ja, Sie k\u00f6nnen es verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79478\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-sommes-superieures-a-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"Sumifs-gr\u00f6\u00dfer-als-null\" width=\"674\" height=\"381\"><\/figure><\/div><p> In SUMIFS m\u00fcssen Sie zun\u00e4chst den sum_range angeben. Danach m\u00fcssen Sie den Kriterienbereich angeben und am Ende die zu testenden Kriterien eingeben.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIFS(C2:C11,B2:B11,\"&gt;0\")<\/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\/08\/somme-si-superieure-a-zero.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\/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-3159","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 addiere ich Werte gr\u00f6\u00dfer als Null? Excel-Berater<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial lernen wir, wie man mit SUMIF eine Excel-Formel schreibt, um Werte gr\u00f6\u00dfer als Null hinzuzuf\u00fcgen. 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\/summe-wenn-grosser-als-null-2\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie addiere ich Werte gr\u00f6\u00dfer als Null? Excel-Berater\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial lernen wir, wie man mit SUMIF eine Excel-Formel schreibt, um Werte gr\u00f6\u00dfer als Null hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:13:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.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=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/\",\"name\":\"Wie addiere ich Werte gr\u00f6\u00dfer als Null? Excel-Berater\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png\",\"datePublished\":\"2023-11-12T15:00:24+00:00\",\"dateModified\":\"2023-12-03T11:13:26+00:00\",\"description\":\"In diesem Tutorial lernen wir, wie man mit SUMIF eine Excel-Formel schreibt, um Werte gr\u00f6\u00dfer als Null hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie addiere ich werte gr\u00f6\u00dfer als null?\"}]},{\"@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 addiere ich Werte gr\u00f6\u00dfer als Null? Excel-Berater","description":"In diesem Tutorial lernen wir, wie man mit SUMIF eine Excel-Formel schreibt, um Werte gr\u00f6\u00dfer als Null hinzuzuf\u00fcgen. 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\/summe-wenn-grosser-als-null-2\/","og_locale":"de_DE","og_type":"article","og_title":"Wie addiere ich Werte gr\u00f6\u00dfer als Null? Excel-Berater","og_description":"In diesem Tutorial lernen wir, wie man mit SUMIF eine Excel-Formel schreibt, um Werte gr\u00f6\u00dfer als Null hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","og_url":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:13:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/","url":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/","name":"Wie addiere ich Werte gr\u00f6\u00dfer als Null? Excel-Berater","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png","datePublished":"2023-11-12T15:00:24+00:00","dateModified":"2023-12-03T11:13:26+00:00","description":"In diesem Tutorial lernen wir, wie man mit SUMIF eine Excel-Formel schreibt, um Werte gr\u00f6\u00dfer als Null hinzuzuf\u00fcgen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/summe-wenn-grosser-als-null-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie addiere ich werte gr\u00f6\u00dfer als null?"}]},{"@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\/3159","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=3159"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3159\/revisions"}],"predecessor-version":[{"id":3834,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3159\/revisions\/3834"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}