{"id":3055,"date":"2023-11-17T04:57:31","date_gmt":"2023-11-17T04:57:31","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/"},"modified":"2023-12-03T11:21:29","modified_gmt":"2023-12-03T11:21:29","slug":"fugen-sie-zufallige-zellen-hinzu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/","title":{"rendered":"Wie f\u00fcge ich zuf\u00e4llige zellen in excel hinzu?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1770173770\"><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>Wenn Sie zuf\u00e4llige Zellen in Excel z\u00e4hlen m\u00f6chten, k\u00f6nnen Sie einfach die SUMME-Funktion verwenden und dann alle diese zuf\u00e4lligen Zellen mit der Maus ausw\u00e4hlen. Auf diese Weise nimmt die Summenfunktion alle von Ihnen ausgew\u00e4hlten Zellen einzeln auf und gibt beim Dr\u00fccken der Eingabetaste die Summe der Werte dieser Zellen zur\u00fcck. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67262\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-somme-cellules-aleatoires1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-Zufallssummenzellen\" width=\"434\" height=\"434\"><\/figure><\/div><p> Mit den folgenden Schritten k\u00f6nnen Sie zuf\u00e4llige Zellen hinzuf\u00fcgen:<\/p><ol><li> W\u00e4hlen Sie die Zelle aus, in der Sie die Summe aller zuf\u00e4lligen Zellen erhalten m\u00f6chten.<\/li><li> Geben Sie anschlie\u00dfend die SUM-Funktion in diese Zelle ein.<\/li><li> Halten Sie von dort aus die Strg-Taste gedr\u00fcckt und w\u00e4hlen Sie nacheinander jede zuf\u00e4llige Zelle aus, f\u00fcr die Sie die Summe berechnen m\u00f6chten.<\/li><li> Geben Sie am Ende die schlie\u00dfenden Klammern ein und dr\u00fccken Sie die Eingabetaste, um die Summe anzuzeigen.<\/li><\/ol><p> Wenn Sie jede Zelle durch Dr\u00fccken der Strg-Taste ausw\u00e4hlen, f\u00fcgt Excel automatisch ein Komma zwischen den einzelnen Zellverweisen ein, sodass Sie es nicht manuell hinzuf\u00fcgen m\u00fcssen. <\/p><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\/94-cellules-aleatoires-somme.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-nur-sichtbare-zellen-hinzu\/\">Summieren Sie nur sichtbare 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-3055","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 zuf\u00e4llige Zellen in Excel hinzu?<\/title>\n<meta name=\"description\" content=\"In diesem Formel-Tutorial lernen wir, wie man mit einer einfachen und benutzerfreundlichen Methode Zufallswerte in Excel hinzuf\u00fcgt.\" \/>\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-zufallige-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 zuf\u00e4llige Zellen in Excel hinzu?\" \/>\n<meta property=\"og:description\" content=\"In diesem Formel-Tutorial lernen wir, wie man mit einer einfachen und benutzerfreundlichen Methode Zufallswerte in Excel hinzuf\u00fcgt.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:21:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-somme-cellules-aleatoires1.gif\" \/>\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-zufallige-zellen-hinzu\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/\",\"name\":\"\u25b7 Wie f\u00fcge ich zuf\u00e4llige Zellen in Excel hinzu?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-somme-cellules-aleatoires1.gif\",\"datePublished\":\"2023-11-17T04:57:31+00:00\",\"dateModified\":\"2023-12-03T11:21:29+00:00\",\"description\":\"In diesem Formel-Tutorial lernen wir, wie man mit einer einfachen und benutzerfreundlichen Methode Zufallswerte in Excel hinzuf\u00fcgt.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-somme-cellules-aleatoires1.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-somme-cellules-aleatoires1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie f\u00fcge ich zuf\u00e4llige 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 zuf\u00e4llige Zellen in Excel hinzu?","description":"In diesem Formel-Tutorial lernen wir, wie man mit einer einfachen und benutzerfreundlichen Methode Zufallswerte in Excel hinzuf\u00fcgt.","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-zufallige-zellen-hinzu\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie f\u00fcge ich zuf\u00e4llige Zellen in Excel hinzu?","og_description":"In diesem Formel-Tutorial lernen wir, wie man mit einer einfachen und benutzerfreundlichen Methode Zufallswerte in Excel hinzuf\u00fcgt.","og_url":"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:21:29+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-somme-cellules-aleatoires1.gif","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-zufallige-zellen-hinzu\/","url":"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/","name":"\u25b7 Wie f\u00fcge ich zuf\u00e4llige Zellen in Excel hinzu?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-somme-cellules-aleatoires1.gif","datePublished":"2023-11-17T04:57:31+00:00","dateModified":"2023-12-03T11:21:29+00:00","description":"In diesem Formel-Tutorial lernen wir, wie man mit einer einfachen und benutzerfreundlichen Methode Zufallswerte in Excel hinzuf\u00fcgt.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-somme-cellules-aleatoires1.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-somme-cellules-aleatoires1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/fugen-sie-zufallige-zellen-hinzu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie f\u00fcge ich zuf\u00e4llige 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\/3055","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=3055"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3055\/revisions"}],"predecessor-version":[{"id":4067,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3055\/revisions\/4067"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}