{"id":1498,"date":"2018-11-11T12:00:15","date_gmt":"2018-11-11T11:00:15","guid":{"rendered":"http:\/\/culmsee.com\/scout-beo\/?page_id=1498"},"modified":"2019-04-23T18:31:41","modified_gmt":"2019-04-23T16:31:41","slug":"excel-bezug-formeln-2","status":"publish","type":"page","link":"https:\/\/culmsee.com\/scout-beo\/index.php\/excel-bezug-formeln-2\/","title":{"rendered":"Excel Bezug-Formeln"},"content":{"rendered":"\n<p style=\"color:#0e9664\" class=\"has-text-color\">Den Pfad komplett angeben, dann klappt es auch mit nicht ge\u00f6ffneten Dateien.<\/p>\n\n\n\n<p style=\"color:#51ae84\" class=\"has-text-color\">Die eingestrichenen Anf\u00fchrungen sind erforderlich bei Benennungen, die Zeichen au\u00dferhalb des Alphabets enthalten. <\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln-1024x727.jpg\" alt=\"Excel Bezug-Formeln\" class=\"wp-image-1499\" width=\"768\" height=\"545\" srcset=\"https:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln-1024x727.jpg 1024w, https:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln-300x213.jpg 300w, https:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln-768x545.jpg 768w, https:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln-500x355.jpg 500w, https:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln-800x568.jpg 800w, https:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln-380x270.jpg 380w, https:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln.jpg 1119w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><figcaption>Excel Bezug-Formeln<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" style=\"text-align:center\"><font color=\"#3ea36f\">=SUMME(\u2019C:\\Ordnername[Dateiname.xlsx]Blattname&#8216;!C10)<\/font><\/h4>\n\n\n\n<p style=\"text-align:center\">bzw. bei Vorhandensein von Unterordnern:<\/p>\n\n\n\n<h5 class=\"wp-block-heading\" style=\"text-align:center\"><font color=\"#3ea36f\">=SUMME(\u2019C:\\Ordnername\\Unterdner-1\\Unterordner-2[Dateiname.xlsx]Blattname&#8216;!C10)<\/font><\/h5>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"50\" height=\"50\" class=\"wp-image-603\" style=\"width: 50px;\" src=\"http:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/03\/PDF-Symbol-4print.jpg\" alt=\"PDF zum Herunterladen und Ausdrucken\"> <a href=\"http:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln.pdf\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"zum Ausdruck (\u00f6ffnet in neuem Tab)\">zum Ausdruck<\/a><\/p>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"http:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/04\/Excel-Bezug-Formeln.pdf\">Herunterladen<\/a><\/div>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"12\" src=\"http:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/03\/Ende-Info-VHS-PC-Kurs-300x12.jpg\" alt=\"Ende dieser Info-Seite VHS-PC-Kurse\" class=\"wp-image-301\"\/><\/figure><\/div>\n\n\n\n\n\n\n<p style=\"text-align:center\">1.193 views\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"12\" src=\"http:\/\/culmsee.com\/scout-beo\/wp-content\/uploads\/2019\/03\/Ende-webLog-300x12.jpg\" alt=\"\" class=\"wp-image-180\"\/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Den Pfad komplett angeben, dann klappt es auch mit nicht ge\u00f6ffneten Dateien. Die eingestrichenen Anf\u00fchrungen sind erforderlich bei Benennungen, die Zeichen au\u00dferhalb des Alphabets enthalten. =SUMME(\u2019C:\\Ordnername[Dateiname.xlsx]Blattname&#8216;!C10) bzw. bei Vorhandensein von Unterordnern: =SUMME(\u2019C:\\Ordnername\\Unterdner-1\\Unterordner-2[Dateiname.xlsx]Blattname&#8216;!C10) zum Ausdruck<\/p>\n","protected":false},"author":1,"featured_media":607,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1498","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/culmsee.com\/scout-beo\/index.php\/wp-json\/wp\/v2\/pages\/1498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/culmsee.com\/scout-beo\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/culmsee.com\/scout-beo\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/culmsee.com\/scout-beo\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/culmsee.com\/scout-beo\/index.php\/wp-json\/wp\/v2\/comments?post=1498"}],"version-history":[{"count":1,"href":"https:\/\/culmsee.com\/scout-beo\/index.php\/wp-json\/wp\/v2\/pages\/1498\/revisions"}],"predecessor-version":[{"id":2107,"href":"https:\/\/culmsee.com\/scout-beo\/index.php\/wp-json\/wp\/v2\/pages\/1498\/revisions\/2107"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/culmsee.com\/scout-beo\/index.php\/wp-json\/wp\/v2\/media\/607"}],"wp:attachment":[{"href":"https:\/\/culmsee.com\/scout-beo\/index.php\/wp-json\/wp\/v2\/media?parent=1498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}