{"id":52813,"date":"2018-05-14T06:52:08","date_gmt":"2018-05-14T05:52:08","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=52813"},"modified":"2022-10-17T07:18:33","modified_gmt":"2022-10-17T06:18:33","slug":"interval-functie-is-cumulatief","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/interval-functie-is-cumulatief\/","title":{"rendered":"INTERVAL functie is cumulatief"},"content":{"rendered":"<p><em><strong>[in de laatste versies van Microsoft 365 (najaar 2022) is INTERVAL niet meer cumulatief]<\/strong><\/em><\/p>\n<p>V. Ik gebruik de functie INTERVAL om gegevens op te delen in categorie\u00ebn, maar het resultaat bevalt me niet: het is cumulatief &#8211; de vorige categorie\u00ebn worden meegeteld. Is dat op te lossen?<\/p>\n<p>A. De functie INTERVAL is eigenlijk een matrix functie, en als je die als matrix functie invoert, is ze niet cumulatief. Dat werkt zo:<\/p>\n<ul>\n<li>Zet de gegevens in een reeks (kolom)<\/li>\n<li>Zet de grenswaarden in een tweede reeks (kolom)<\/li>\n<li>Bereken met INTERVAL in ene derde kolom\n<pre>=INTERVAL(A:A;C2:C13)<\/pre>\n<\/li>\n<\/ul>\n<p><strong>TIP 1<\/strong><\/p>\n<ul>\n<li>Selecteer de eerste cel van resultaten, en de volgende<\/li>\n<li>Druk op F2 (bewerken)<\/li>\n<li>Doe ctrl+shift+enter om door te voeren als matrixformule<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-52814\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/05\/postcode-300x196.png\" alt=\"\" width=\"300\" height=\"196\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/05\/postcode-300x196.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/05\/postcode.png 514w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Opgelet: we zien intu\u00c3\u00aftief die tabel als &#8220;vanaf &#8230;&#8221; maar er staat eigenlijk &#8220;tot &#8230;.&#8221;<\/p>\n<p><strong>TIP 2<\/strong><\/p>\n<ul>\n<li>Lastig? Zet de grenswaarden in de omgekeerde volgorde.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-54421\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/05\/interval-inverted-300x252.png\" alt=\"\" width=\"300\" height=\"252\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/05\/interval-inverted-300x252.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/05\/interval-inverted.png 391w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<\/ul>\n<p><a href=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/05\/postcode.xlsx\">postcodes: een voorbeld in Excel<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[in de laatste versies van Microsoft 365 (najaar 2022) is INTERVAL niet meer cumulatief] V. Ik gebruik de functie INTERVAL om gegevens op te delen in categorie\u00ebn, maar het resultaat bevalt me niet: het is cumulatief &#8211; de vorige categorie\u00ebn worden meegeteld. Is dat op te lossen? A. De functie<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":23,"footnotes":""},"categories":[448,538,54,79,10,160],"tags":[],"class_list":["post-52813","post","type-post","status-publish","format-standard","hentry","category-draaitabel","category-enquetes","category-excel","category-odisee","category-office","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 03:16:52","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/52813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=52813"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/52813\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=52813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=52813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=52813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}