{"id":1695,"date":"2023-11-11T10:48:33","date_gmt":"2023-11-11T10:48:33","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/"},"modified":"2023-12-06T05:55:53","modified_gmt":"2023-12-06T05:55:53","slug":"gemiddelde-van-niet-lege-cellen-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/","title":{"rendered":"Gemiddelde alleen niet-lege cellen in excel"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-668907084\"><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 het gemiddelde van alleen niet-lege cellen in Excel te berekenen, moet u de functie AVERAGEIF gebruiken. En in de criteria moet u de operator <a href=\"https:\/\/exceladvisor.org\/nl\/is-niet-gelijk\/\">is niet gelijk<\/a> gebruiken om alleen naar niet-lege cellen te verwijzen. In deze tutorial zullen we deze formule diepgaand bekijken.<\/p><h2 class=\"wp-block-heading\"> Gemiddelde alleen cellen die niet leeg zijn<\/h2><p> U kunt de volgende stappen gebruiken:<\/p><ol type=\"1\"><li> Voer eerst in cel C1 de functie AVERAGEIF in.<\/li><li> Daarna verwijst u in het eerste argument (bereik) naar het bereik A1:A9.<\/li><li> In het tweede argument is enter niet gelijk aan de operator die dubbele aanhalingstekens gebruikt.<\/li><li> Voer aan het einde de afsluitende haakjes in en druk op Enter om het resultaat te krijgen. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79245\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"gemiddelden voor niet-lege cellen\" width=\"484\" height=\"525\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AVERAGEIF(A1:A9,\"&lt;&gt;\")<\/code><\/pre><p> Wanneer u het gebruikt, houdt AVERAGEIF alleen rekening met cellen die niet leeg zijn en berekent het gemiddelde alleen die cellen. Je kunt zien dat wanneer ik de cellen selecteer waar we een waarde hebben, hetzelfde gemiddelde wordt weergegeven in de <a href=\"https:\/\/exceladvisor.org\/nl\/statusbalk\/\">statusbalk<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79246\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-resultat-moyen-pour-les-cellules-non-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"gemiddelde-resultaat-voor-niet-lege-cellen\" width=\"589\" height=\"324\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Een probleem waarmee u te maken kunt krijgen<\/h2><p> Het kan gebeuren dat u een lege cel in het bereik heeft en die lege cel onzichtbare ruimte heeft. In dit geval beschouwt uw formule deze cel niet als een blanco cel en wordt ook het gemiddelde berekend, inclusief de cel.<\/p><p> Welnu, je kunt de onderstaande formule gebruiken waarin we AVERAGEIF hebben gebruikt om twee criteria op te geven: de ene is om niet-lege cellen op te nemen en de andere is om cellen met een spatie te negeren.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AVERAGEIFS(A1:A9,A1:A9,\"&lt;&gt;\",A1:A9,\"&lt;&gt;\"&amp;\" \")<\/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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/moyenne-des-cellules-non-vides.xlsx\" rel=\"nofollow\">Downloaden<\/a><\/p><\/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\/gemiddelde-maximale-waarden\/\">Gemiddelde van de 5 hoogste waarden in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/gewogen-gemiddelde\/\">Bereken het gewogen gemiddelde in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/gemiddelde-genegeerde-fouten-2\/\">Gemiddeld maar negeer fouten (#n.v.t. en andere fouten)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/het-gemiddelde-is-exclusief-nullen-2\/\">Gemiddeld aantal, maar exclusief nullen<\/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-1695","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>Gemiddelde alleen niet-lege cellen in Excel<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een Excel-formule schrijft om alleen het gemiddelde te berekenen van cellen die niet leeg zijn. Laten we dit controleren...\" \/>\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\/gemiddelde-van-niet-lege-cellen-2\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gemiddelde alleen niet-lege cellen in Excel\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een Excel-formule schrijft om alleen het gemiddelde te berekenen van cellen die niet leeg zijn. Laten we dit controleren...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:55:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.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\/gemiddelde-van-niet-lege-cellen-2\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/\",\"name\":\"Gemiddelde alleen niet-lege cellen in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png\",\"datePublished\":\"2023-11-11T10:48:33+00:00\",\"dateModified\":\"2023-12-06T05:55:53+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een Excel-formule schrijft om alleen het gemiddelde te berekenen van cellen die niet leeg zijn. Laten we dit controleren...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Gemiddelde alleen niet-lege cellen 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":"Gemiddelde alleen niet-lege cellen in Excel","description":"In deze zelfstudie leert u hoe u een Excel-formule schrijft om alleen het gemiddelde te berekenen van cellen die niet leeg zijn. Laten we dit controleren...","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\/gemiddelde-van-niet-lege-cellen-2\/","og_locale":"nl_NL","og_type":"article","og_title":"Gemiddelde alleen niet-lege cellen in Excel","og_description":"In deze zelfstudie leert u hoe u een Excel-formule schrijft om alleen het gemiddelde te berekenen van cellen die niet leeg zijn. Laten we dit controleren...","og_url":"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:55:53+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.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\/gemiddelde-van-niet-lege-cellen-2\/","url":"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/","name":"Gemiddelde alleen niet-lege cellen in Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png","datePublished":"2023-11-11T10:48:33+00:00","dateModified":"2023-12-06T05:55:53+00:00","description":"In deze zelfstudie leert u hoe u een Excel-formule schrijft om alleen het gemiddelde te berekenen van cellen die niet leeg zijn. Laten we dit controleren...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-si-pour-les-cellules-non-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/gemiddelde-van-niet-lege-cellen-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Gemiddelde alleen niet-lege cellen 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\/1695","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=1695"}],"version-history":[{"count":2,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1695\/revisions"}],"predecessor-version":[{"id":3020,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1695\/revisions\/3020"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}