{"id":1690,"date":"2023-11-11T12:06:18","date_gmt":"2023-11-11T12:06:18","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/"},"modified":"2023-12-06T05:48:46","modified_gmt":"2023-12-06T05:48:46","slug":"indirecte-som-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/","title":{"rendered":"Hoe gebruik je indirect met sum in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2331572794\"><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>Wanneer u INDIRECT combineert met de SUM-functie, kunt u een dynamische somformule maken. En met deze formule kunt u verwijzen naar een cel waar u het bereik (in tekstvorm) hebt waarvoor u de som wilt. Dit betekent dat u de verwijzing naar de formule zelf niet steeds opnieuw hoeft te wijzigen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80191\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"gebruik-indirect-met-som\" width=\"458\" height=\"421\"><\/figure><\/div><p class=\"grey-note\"> Met INDIRECT kunt u een cel- of bereikverwijzing maken door er tekst in te typen.<\/p><h2 class=\"wp-block-heading\"> Combineer INDIRECT met SOM<\/h2><p> U kunt de onderstaande stappen gebruiken:<\/p><ul><li> Voer eerst in een cel het bereik in waarnaar u wilt verwijzen.<\/li><li> Voer daarna in een andere cel de SOM-functie in.<\/li><li> Voer vervolgens de functie INDIRECT in en verwijs in het eerste argument van INDIRECT naar de cel met het bereikadres.<\/li><li> Sluit nu beide functies en druk op Enter om het resultaat te krijgen. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80192\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-combiner-indirect-et-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"combineer-indirect-en-som\" width=\"522\" height=\"394\"><\/figure><\/div><p> Op het moment dat u op Enter drukt, retourneert het de som van de waarden in het bereik A2:A7. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80193\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-de-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"som van waarden\" width=\"405\" height=\"305\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gebruik INDIRECT om naar een ander blad bij SUM te verwijzen<\/h2><p> Stel dat u een bereik heeft dat zich in een ander blad bevindt, in dit geval kunt u ook INDIRECT en SUM gebruiken. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80194\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-indirect-pour-renvoyer-une-autre-feuille-a-la-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"indirect-om-naar-een-ander-blad-te-verwijzen\" width=\"672\" height=\"280\"><\/figure><\/div><p> In het bovenstaande voorbeeld hebben we de formule ingevoerd in &#8216;Blad2&#8217; en verwezen naar het bereik op het tabblad &#8216;Gegevens&#8217;. En in de formule zijn er twee verschillende cellen met waarden waarnaar moet worden verwezen. In de eerste cel heb je de naam van het blad en in de tweede cel het bereik zelf.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(INDIRECT(A1&amp;\"!\"&amp;B1))<\/code><\/pre><h2 class=\"wp-block-heading\"> Gebruik INDIRECT voor SUM met meerdere bladen<\/h2><p> Als u meerdere bladen heeft en de waarden van een bereik van al deze bladen wilt optellen, moet u een formule zoals hieronder gebruiken: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80195\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-indirects-pour-additionner-plusieurs-feuilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"indirect-naar-som-meerdere-bladeren\" width=\"713\" height=\"220\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(SUMIF(INDIRECT(\"'\"&amp;A2:A4&amp;\"'!\"&amp;B2),\"&gt;0\"))<\/code><\/pre><p> In deze formule hebben we SOMPRODUCT en SUMIF gebruikt in plaats van SOM. In de INDIRECT wordt verwezen naar de naam van de bladen en het assortiment. Hierdoor ontstaat een <a href=\"https:\/\/exceladvisor.org\/nl\/referentie-3d\/\">3D-bereik<\/a> voor het A2:A7-bereik in alle drie de bladen (Data1, Data2 en Data3). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80196\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-sumproduit-cumule-sumif.png\" sizes=\"auto, \" srcset=\"\" alt=\"som-product-gecombineerd-sumsi\" width=\"638\" height=\"304\"><\/figure><\/div><p> Daarna gebruikt SUMIF dit bereik en retourneert de individuele sommen van de drie bereiken. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80197\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-sumif-utilise-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-gebruikt-het-bereik\" width=\"676\" height=\"270\"><\/figure><\/div><p> Uiteindelijk gebruikt SUMPRODUCT deze waarden en retourneert een enkele somwaarde in de cel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80198\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-sumproduct-renvoie-une-seule-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"somproduct-retourneert-\u00e9\u00e9n-som\" width=\"591\" height=\"242\"><\/figure><\/div><p> U kunt hier meer leren over het gebruik van <a href=\"https:\/\/exceladvisor.org\/nl\/voorwaarde-in-somproduct\/\">SUMPRODUCT IF<\/a> en hier meer duidelijkheid krijgen over het gebruik ervan. <\/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\/somme-indirecte.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 hele kolom of rij toe in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-alleen-zichtbare-cellen-toe\/\">Tel alleen zichtbare cellen op 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-1690","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 gebruik je INDIRECT met SUM in Excel?<\/title>\n<meta name=\"description\" content=\"In deze tutorial leert u hoe u een Excel-formule schrijft om de INDIRECT-functie te combineren met de SOM. 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\/indirecte-som-2\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe gebruik je INDIRECT met SUM in Excel?\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leert u hoe u een Excel-formule schrijft om de INDIRECT-functie te combineren met de SOM. Laten we dit controleren...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:48:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.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\/indirecte-som-2\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/\",\"name\":\"\u25b7 Hoe gebruik je INDIRECT met SUM in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png\",\"datePublished\":\"2023-11-11T12:06:18+00:00\",\"dateModified\":\"2023-12-06T05:48:46+00:00\",\"description\":\"In deze tutorial leert u hoe u een Excel-formule schrijft om de INDIRECT-functie te combineren met de SOM. Laten we dit controleren...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe gebruik je indirect met sum 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 gebruik je INDIRECT met SUM in Excel?","description":"In deze tutorial leert u hoe u een Excel-formule schrijft om de INDIRECT-functie te combineren met de SOM. 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\/indirecte-som-2\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe gebruik je INDIRECT met SUM in Excel?","og_description":"In deze tutorial leert u hoe u een Excel-formule schrijft om de INDIRECT-functie te combineren met de SOM. Laten we dit controleren...","og_url":"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:48:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.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\/indirecte-som-2\/","url":"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/","name":"\u25b7 Hoe gebruik je INDIRECT met SUM in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png","datePublished":"2023-11-11T12:06:18+00:00","dateModified":"2023-12-06T05:48:46+00:00","description":"In deze tutorial leert u hoe u een Excel-formule schrijft om de INDIRECT-functie te combineren met de SOM. Laten we dit controleren...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utilisation-indirecte-avec-somme.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/indirecte-som-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe gebruik je indirect met sum 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\/1690","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=1690"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1690\/revisions"}],"predecessor-version":[{"id":2560,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1690\/revisions\/2560"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}