{"id":1617,"date":"2023-11-15T10:25:02","date_gmt":"2023-11-15T10:25:02","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/som-4\/"},"modified":"2023-12-06T05:55:39","modified_gmt":"2023-12-06T05:55:39","slug":"som-4","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/som-4\/","title":{"rendered":"Excel-functie: sumif"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-760457508\"><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> <div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"0-intro-sumif-function\" class=\"wp-block-heading\"> Inleiding: SUMIF-functie<\/h2><p> Als u in Excel de functie SOM.ALS gebruikt, retourneert deze de som van de waarden die voldoen aan de voorwaarde die u opgeeft. U moet het celbereik opgeven dat moet worden gecontroleerd op de voorwaarde, vervolgens een waarde die moet worden gecontroleerd als voorwaarde, en aan het einde een bereik waaruit de waarden moeten worden opgeteld. Er zijn dus drie argumenten te specificeren. <\/p><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"1-syntax\" class=\"wp-block-heading\"> Syntaxis<\/h2><p> SOM.ALS(bereik; criteria, [som_bereik]) <\/p><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"2-arguments\" class=\"wp-block-heading\"> Argumenten<\/h2><ul><li> <strong>bereik<\/strong> : een celbereik waarvan u de criteria wilt controleren.<\/li><li> <strong>criteria<\/strong> : een criterium dat een getal, tekst, uitdrukking, celverwijzing of functie kan zijn.<\/li><li> <strong>[sum_range]<\/strong> : een celbereik met de waarden die u wilt optellen. <\/li><\/ul><\/div><\/div><div class=\"wp-block-group is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 id=\"3-example\" class=\"wp-block-heading\"> Voorbeeld<\/h2><p> In het onderstaande voorbeeld hebben we A1:A9 gespecificeerd als het criteriumbereik en B1:B9 als het sombereik en daarna hebben we de criteria in A12 gespecificeerd die de waarde C hebben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-som-functie-voorbeeld-1\" width=\"416\" height=\"469\"><\/figure><\/div><p> U kunt criteria ook rechtstreeks in de functie invoegen. In het onderstaande voorbeeld hebben we een jokerteken met een asterisk gebruikt om een criterium op te geven met het alfabet &#8216;S&#8217;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37334\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-som-functie-voorbeeld-2\" width=\"457\" height=\"488\"><\/figure><\/div><p> En als u het sombereik negeert, krijgt u de som van het criteriabereik. Maar dit is alleen mogelijk als het criteriabereik numerieke waarden heeft. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-som-functie-voorbeeld-3\" width=\"449\" height=\"450\"><\/figure><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> Voorbeeld bestand<\/h2><p> <em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-2.xlsx\">Download een voorbeeldbestand<\/a><\/em> <\/p><div class=\"wp-block-group main-page-bottom is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 id=\"4-related\" class=\"wp-block-heading\"> Meer tutorials<\/h2><ul><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/nl\/sumif-met-jokertekens\/\">SUMIF met jokertekens in Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/nl\/som-van-waarden-tussen-twee-datums\/\">Som van waarden tussen twee datums in Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/nl\/sumif-sumifs-of-logica\/\">SUMIF\/SUMIFS met OR-logica in Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/nl\/sumives-niet-gelijk\/\">Som van niet-gelijke waarden (SUMIFS) in Excel<\/a><\/li><li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/nl\/som-indien-groter-dan\/\">Tel grotere waarden op met SUMIF in Excel<\/a><\/li><\/ul><h2 class=\"wp-block-heading\"> Gerelateerde functies<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/samenvattingen-2\/\">Excel SUM-functie<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/somproduct-2\/\">Excel-functie SOMPRODUCT<\/a><\/li><\/ul><\/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-1617","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>SUMIF-functie in Excel (snelle Excel-zelfstudie)<\/title>\n<meta name=\"description\" content=\"Deze tutorial laat zien hoe u de SUMIF-functie van Excel kunt gebruiken om waarden toe te voegen met behulp van een criterium.\" \/>\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\/som-4\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SUMIF-functie in Excel (snelle Excel-zelfstudie)\" \/>\n<meta property=\"og:description\" content=\"Deze tutorial laat zien hoe u de SUMIF-functie van Excel kunt gebruiken om waarden toe te voegen met behulp van een criterium.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/som-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:55:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.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\/som-4\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/som-4\/\",\"name\":\"SUMIF-functie in Excel (snelle Excel-zelfstudie)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"datePublished\":\"2023-11-15T10:25:02+00:00\",\"dateModified\":\"2023-12-06T05:55:39+00:00\",\"description\":\"Deze tutorial laat zien hoe u de SUMIF-functie van Excel kunt gebruiken om waarden toe te voegen met behulp van een criterium.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-4\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/som-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-4\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel-functie: sumif\"}]},{\"@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":"SUMIF-functie in Excel (snelle Excel-zelfstudie)","description":"Deze tutorial laat zien hoe u de SUMIF-functie van Excel kunt gebruiken om waarden toe te voegen met behulp van een criterium.","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\/som-4\/","og_locale":"nl_NL","og_type":"article","og_title":"SUMIF-functie in Excel (snelle Excel-zelfstudie)","og_description":"Deze tutorial laat zien hoe u de SUMIF-functie van Excel kunt gebruiken om waarden toe te voegen met behulp van een criterium.","og_url":"https:\/\/exceladvisor.org\/nl\/som-4\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:55:39+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.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\/som-4\/","url":"https:\/\/exceladvisor.org\/nl\/som-4\/","name":"SUMIF-functie in Excel (snelle Excel-zelfstudie)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/som-4\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/som-4\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","datePublished":"2023-11-15T10:25:02+00:00","dateModified":"2023-12-06T05:55:39+00:00","description":"Deze tutorial laat zien hoe u de SUMIF-functie van Excel kunt gebruiken om waarden toe te voegen met behulp van een criterium.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/som-4\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/som-4\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/som-4\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/som-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Excel-functie: sumif"}]},{"@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\/1617","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=1617"}],"version-history":[{"count":2,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1617\/revisions"}],"predecessor-version":[{"id":3005,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1617\/revisions\/3005"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}