{"id":1558,"date":"2023-11-17T07:02:42","date_gmt":"2023-11-17T07:02:42","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/"},"modified":"2023-12-06T05:50:35","modified_gmt":"2023-12-06T05:50:35","slug":"tel-het-totale-aantal-cellen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/","title":{"rendered":"Hoe tel je het totale aantal cellen in een bereik?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1335064932\"><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>In Excel kunt u twee verschillende formules gebruiken als u het aantal cellen in een bereik wilt tellen (lege en niet-lege cellen). In deze zelfstudie bekijken we beide formules.<\/p><h2 class=\"wp-block-heading\"> Tel het aantal cellen (methode-1)<\/h2><p> In het volgende voorbeeld hebben we enkele waarden in kolom A en moet u de cellen in het bereik A1:B10 tellen. En hiervoor gaan we de functies RIJEN en KOLOMMEN gebruiken.<\/p><p> Stappen om de formule te schrijven:<\/p><ol type=\"1\"><li> Voer eerst in cel D1 &#8221; <code>=ROWS (A1:B10)<\/code> &#8221; in.<\/li><li> Typ vervolgens het sterretje (*) om de waarden te vermenigvuldigen.<\/li><li> Daarna moet u de KOLOM-functie invoeren die verwijst naar hetzelfde bereik (KOLOMMEN(A1:B10).<\/li><li> Druk aan het einde op de knop Enter om het resultaat in de cel weer te geven. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66794\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"rijen en kolommen functioneren\" width=\"445\" height=\"273\"><\/figure><\/div><p> Zoals je kunt zien, retourneert het resultaat 20 als je op Enter drukt, omdat je in totaal 20 cellen hebt in het bereik dat je hebt opgegeven. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66795\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Resultat-de-comptage-de-2-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"resultaat celtelling\" width=\"496\" height=\"303\"><\/figure><\/div><p> Laten we nu proberen de formule te begrijpen die we hier hebben gebruikt. In het eerste deel hebben we de functie RIJEN gebruikt, die het aantal rijen in een bereik retourneert. Hier retourneert het 10 omdat je tien rijen hebt in het bereik A1 tot B10. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66796\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-3-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"lijnen formule\" width=\"471\" height=\"332\"><\/figure><\/div><p> De volgende keer heeft u de functie KOLOMMEN die het aantal kolommen in een bereik retourneert. Hier retourneert het 2 omdat je twee kolommen hebt in het bereik A1 tot B10. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66797\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-4-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"formule-kolommen\" width=\"421\" height=\"286\"><\/figure><\/div><p> Uiteindelijk heb je een sterretje tussen de twee waarden om de rijen en kolommen te vermenigvuldigen om het totale aantal cellen in het bereik te krijgen.<\/p><h2 class=\"wp-block-heading\"> Combineert COUNTA \u2013 COUNTBLANK om cellen in een bereik te tellen<\/h2><p> Voor de tweede methode moet u de functies COUNTA en COUNTBLANK combineren. Door de twee functies te combineren, kunt u alle niet-lege cellen en alle lege cellen in een bereik tellen. Hieronder hebben we hetzelfde voorbeeld dat we in het eerste voorbeeld hebben gebruikt.<\/p><p> In cel D1 kunt u de volgende formule invoeren: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTA(A1:B10)+COUNTBLANK(A1:B10)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66798\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-counta-countblank-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"counta-countblank-formule\" width=\"546\" height=\"280\"><\/figure><\/div><p> Zoals ik al zei, werkt deze formule in twee delen:<\/p><ol type=\"1\"><li> De functie COUNTA telt cellen waarin u waarden heeft.<\/li><li> De functie AANTALBLANK telt cellen waarin u geen waarden hebt.<\/li><\/ol><p> Uiteindelijk heb je een &#8220;+ teken&#8221; dat de twee getallen bij elkaar optelt en je het totale aantal cellen retourneert dat je hebt in het bereik dat je hebt opgegeven. <\/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\"> 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\/08\/compter-les-cellules-dune-plage.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\/tel-cellen-met-tekst\/\">Tel cellen met tekst in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/specifieke-karakters-tellen\/\">Tel specifieke tekens in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/unieke-waarden-tellen-1\/\">Tel unieke waarden in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tellen-tegen-tellen\/\">COUNT versus COUNTA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tel-de-woorden\/\">Tel woorden 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-1558","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 tel je het totale aantal cellen in een bereik?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u verschillende manieren om het totale aantal cellen in een bereik in Excel te tellen met behulp van\" \/>\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\/tel-het-totale-aantal-cellen\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe tel je het totale aantal cellen in een bereik?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u verschillende manieren om het totale aantal cellen in een bereik in Excel te tellen met behulp van\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.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=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/\",\"name\":\"\u25b7 Hoe tel je het totale aantal cellen in een bereik?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\",\"datePublished\":\"2023-11-17T07:02:42+00:00\",\"dateModified\":\"2023-12-06T05:50:35+00:00\",\"description\":\"In deze zelfstudie leert u verschillende manieren om het totale aantal cellen in een bereik in Excel te tellen met behulp van\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe tel je het totale aantal cellen in een bereik?\"}]},{\"@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 tel je het totale aantal cellen in een bereik?","description":"In deze zelfstudie leert u verschillende manieren om het totale aantal cellen in een bereik in Excel te tellen met behulp van","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\/tel-het-totale-aantal-cellen\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe tel je het totale aantal cellen in een bereik?","og_description":"In deze zelfstudie leert u verschillende manieren om het totale aantal cellen in een bereik in Excel te tellen met behulp van","og_url":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:35+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/","url":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/","name":"\u25b7 Hoe tel je het totale aantal cellen in een bereik?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png","datePublished":"2023-11-17T07:02:42+00:00","dateModified":"2023-12-06T05:50:35+00:00","description":"In deze zelfstudie leert u verschillende manieren om het totale aantal cellen in een bereik in Excel te tellen met behulp van","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/tel-het-totale-aantal-cellen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe tel je het totale aantal cellen in een bereik?"}]},{"@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\/1558","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=1558"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1558\/revisions"}],"predecessor-version":[{"id":2753,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1558\/revisions\/2753"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}