{"id":50820,"date":"2017-02-08T18:13:36","date_gmt":"2017-02-08T17:13:36","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=50820"},"modified":"2017-02-05T10:21:12","modified_gmt":"2017-02-05T09:21:12","slug":"optellen-over-werkbladen-heen","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/optellen-over-werkbladen-heen\/","title":{"rendered":"Optellen over werkbladen heen"},"content":{"rendered":"<p>Een Exceltip: als je een aantal werkbladen hebt met dezelfde structuur (waar hetzelfde gegeven op die verschillende bladen in dezelfde cel hebt staan), kan je transversaal rekenen &#8211; je kan een som of gemiddelde berekenen. Bijvoorbeeld: als ik drie opeenvolgende bladen heb met op A1 een waarde dei me interesseert, kan ik die optellen met <strong>=SOM(Blad1:Blad3!A1)<\/strong><\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-transversaalrekenen.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50821\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-transversaalrekenen-300x189.png\" alt=\"\" width=\"300\" height=\"189\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-transversaalrekenen-300x189.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-transversaalrekenen.png 704w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Meer weten? Lees bv.<\/p>\n<p><a href=\"http:\/\/smallbusiness.chron.com\/sum-across-worksheets-microsoft-excel-75858.html\">How to Sum Across Worksheets in Microsoft Excel<\/a><br \/>\n<a href=\"https:\/\/www.exceltip.com\/summing\/summing-values-from-cells-in-different-sheets.html\">Sum Across Multiple Sheets in Microsoft Excel<\/a><br \/>\n<a href=\"http:\/\/excel.tips.net\/T002514_Totaling_Across_Worksheets.html\">Totaling Across Worksheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Een Exceltip: als je een aantal werkbladen hebt met dezelfde structuur (waar hetzelfde gegeven op die verschillende bladen in dezelfde cel hebt staan), kan je transversaal rekenen &#8211; je kan een som of gemiddelde berekenen. Bijvoorbeeld: als ik drie opeenvolgende bladen heb met op A1 een waarde dei me interesseert,<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":2,"footnotes":""},"categories":[464,54,79,10,160],"tags":[],"class_list":["post-50820","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-odisee","category-office","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 13:38:11","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\/50820","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=50820"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50820\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=50820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=50820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=50820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}