{"id":1565,"date":"2023-11-17T04:34:59","date_gmt":"2023-11-17T04:34:59","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/"},"modified":"2023-12-06T05:48:50","modified_gmt":"2023-12-06T05:48:50","slug":"voeg-alleen-zichtbare-cellen-toe","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/","title":{"rendered":"Hoe gefilterde cellen toevoegen in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1104296220\"><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>Om alleen waarden uit zichtbare cellen in Excel op te tellen (dat wil zeggen wanneer u een filter hebt toegepast), moet u de functie SUBTOTAAL gebruiken. Met deze functie kun je naar het hele bereik verwijzen, maar zodra je een filter toepast, werkt deze dynamisch en wordt de som alleen voor zichtbare cellen weergegeven.<\/p><p> In het volgende voorbeeld hebben we een lijst met waarden in de kolom en ik wil een formule maken die mij de som kan laten zien telkens wanneer ik een filter op de kolom toepas. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67630\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"lijst met waarden\" width=\"429\" height=\"404\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gebruik SUBTOTAAL om alleen de cellen op te tellen<\/h2><ol type=\"1\"><li> Voer eerst in cel B1 de functie SUBTOTAAL in.<\/li><li> Voer daarna in het eerste argument 9 of 109 in.<\/li><li> Geef vervolgens in het tweede argument het bereik op in kolom A, waar u het nummer vindt.<\/li><li> Voer aan het einde de afsluitende haakjes in en druk op Enter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67631\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sous-total-a-sommer.png\" sizes=\"auto, \" srcset=\"\" alt=\"subtotaal naar som\" width=\"871\" height=\"261\"><\/figure><\/div><p> In de volgende momentopname heb ik het filter nog niet toegepast en wordt de som weergegeven van alle waarden die ik binnen het bereik heb. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67632\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-resultat-de-sous-total.png\" sizes=\"auto, \" srcset=\"\" alt=\"subtotaal-resultaat\" width=\"489\" height=\"277\"><\/figure><\/div><p> Om deze functie te testen, kunt u <a href=\"https:\/\/exceladvisor.org\/nl\/filteren-1\/\" data-wpil=\"url\">een filter toevoegen en toepassen<\/a> . Dus ik ga 1, 2 en 3 uit het filter selecteren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67633\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ajouter-un-filtre.png\" sizes=\"auto, \" srcset=\"\" alt=\"filter toevoegen\" width=\"519\" height=\"453\"><\/figure><\/div><p> En op het moment dat ik op Enter druk, wordt de som alleen voor de gefilterde cellen weergegeven (zichtbaar). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67634\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-somme-des-valeurs-filtrees.png\" sizes=\"auto, \" srcset=\"\" alt=\"som van gefilterde waarden\" width=\"505\" height=\"252\"><\/figure><\/div><p> Nu is deze functie dynamisch en zodra u het filter wijzigt, verandert de resultaatwaarde afhankelijk van de zichtbare cellen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67635\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-fonction-de-sous-total-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"dynamische subtotaalfunctie\" width=\"522\" height=\"355\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUBTOTAL(9,A2:A1001)<\/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\"> Haal het Excel-bestand op<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/additionner-les-cellules-visibles.xlsx\" rel=\"nofollow\">Downloaden<\/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\/nl\/formules\/\">Lijst met Excel-formules<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Gerelateerde formules <\/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\/nl\/voeg-de-hele-kolom-toe\/\">Voeg een volledige kolom of rij toe in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/willekeurige-cellen-toevoegen\/\">Som van willekeurige cellen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/totale-lijn\/\">Voeg een totaalrij toe in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/autosom-1\/\">Gebruik AutoSom snel 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-1565","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 Hoe gefilterde cellen toevoegen in Excel?<\/title>\n<meta name=\"description\" content=\"In deze formule-tutorial leren we hoe u alleen de zichtbare cellen, dat wil zeggen de gefilterde cellen, kunt toevoegen.\" \/>\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\/nl\/voeg-alleen-zichtbare-cellen-toe\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe gefilterde cellen toevoegen in Excel?\" \/>\n<meta property=\"og:description\" content=\"In deze formule-tutorial leren we hoe u alleen de zichtbare cellen, dat wil zeggen de gefilterde cellen, kunt toevoegen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:48:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/\",\"name\":\"\u25b7 Hoe gefilterde cellen toevoegen in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\",\"datePublished\":\"2023-11-17T04:34:59+00:00\",\"dateModified\":\"2023-12-06T05:48:50+00:00\",\"description\":\"In deze formule-tutorial leren we hoe u alleen de zichtbare cellen, dat wil zeggen de gefilterde cellen, kunt toevoegen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe gefilterde cellen toevoegen in excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Hoe gefilterde cellen toevoegen in Excel?","description":"In deze formule-tutorial leren we hoe u alleen de zichtbare cellen, dat wil zeggen de gefilterde cellen, kunt toevoegen.","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\/nl\/voeg-alleen-zichtbare-cellen-toe\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe gefilterde cellen toevoegen in Excel?","og_description":"In deze formule-tutorial leren we hoe u alleen de zichtbare cellen, dat wil zeggen de gefilterde cellen, kunt toevoegen.","og_url":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:48:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/","url":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/","name":"\u25b7 Hoe gefilterde cellen toevoegen in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png","datePublished":"2023-11-17T04:34:59+00:00","dateModified":"2023-12-06T05:48:50+00:00","description":"In deze formule-tutorial leren we hoe u alleen de zichtbare cellen, dat wil zeggen de gefilterde cellen, kunt toevoegen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe gefilterde cellen toevoegen in excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1565"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1565\/revisions"}],"predecessor-version":[{"id":2566,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1565\/revisions\/2566"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}