{"id":1682,"date":"2023-11-11T15:36:54","date_gmt":"2023-11-11T15:36:54","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/autosom-1\/"},"modified":"2023-12-06T05:58:12","modified_gmt":"2023-12-06T05:58:12","slug":"autosom-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/autosom-1\/","title":{"rendered":"Hoe gebruik ik autosum in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-4047811784\"><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 autosom in Excel te gebruiken, moet u de cel onder of rechts van de waarden selecteren die u wilt toevoegen. Zodra u dat heeft gedaan, kunt u de sneltoets gebruiken of de optie op het tabblad Start van het lint gebruiken. AutoSom is een optie om snel de som te berekenen van de waarden die je in een bereik hebt.<\/p><h2 class=\"wp-block-heading\"> Autosom voor een kolom<\/h2><p> U kunt de volgende stappen gebruiken:<\/p><ol><li> Selecteer eerst de cel direct onder de laatste cel met een waarde. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-laatste-cel-onder-waarden\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"last-cell-below-values\" width=\"402\" height=\"297\"><\/li><li> Ga daarna naar het tabblad Start en klik op het vervolgkeuzemenu AutoSom. <br><img loading=\"lazy\" decoding=\"async\" title=\"Vervolgkeuzelijst Automatisch optellen 2\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-liste-deroulante-de-somme-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"autosum-drop-down\" width=\"476\" height=\"231\"><\/li><li> Selecteer nu &#8220;Som&#8221; in de vervolgkeuzelijst. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-som-van-vervolgkeuzemenu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-du-menu-deroulant.png\" sizes=\"auto, \" srcset=\"\" alt=\"sum-from-drop-down\" width=\"214\" height=\"252\"><\/li><li> Zodra u deze selecteert, wordt de somfunctie in de geselecteerde cel ingevoegd, verwijzend naar het bereik boven de cel. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-functie-som-met-bereik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-somme-avec-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"sum-function-with-range\" width=\"293\" height=\"352\"><\/li><li> Druk aan het einde op Enter om het resultaat te krijgen.<\/li><\/ol><p> Dit geeft u dezelfde SOM-functie die u handmatig in een cel invoegt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79233\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fonction-somme1.png\" sizes=\"auto, \" srcset=\"\" alt=\"som functie\" width=\"439\" height=\"384\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Autosom voor een kolom<\/h2><p> Als je het totaal voor een rij wilt zien, moet je de cel rechts van de waarden selecteren (naast de laatste waarde). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79234\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-au-total-de-rangee.png\" sizes=\"auto, \" srcset=\"\" alt=\"lijn totaal\" width=\"584\" height=\"131\"><\/figure><\/div><p> Gebruik nu dezelfde stappen als voor de kolom. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79235\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-somme-pour-les-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"som voor lijnen\" width=\"684\" height=\"161\"><\/figure><\/div><p> Druk aan het einde op Enter om de som te krijgen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79236\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-appuyez-sur-entree-pour-obtenir-la-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"druk op enter om de som te krijgen\" width=\"685\" height=\"155\"><\/figure><\/div><h2 class=\"wp-block-heading\"> De sneltoets voor AutoSom gebruiken<\/h2><p> U kunt ook een sneltoets gebruiken voor autosom. Het enige dat u hoeft te doen, is de cel selecteren en vervolgens op de sneltoets Alt+= drukken. U kunt er meer over leren op deze pagina. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79237\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-raccourci-pour-la-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"sneltoets voor som\" width=\"306\" height=\"142\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gebruik autosum voor een hele tabel<\/h2><p> U kunt autosum ook gebruiken om een totaalrij en kolom aan een tabel in Excel toe te voegen. Selecteer de cellen onder de kolommen en vervolgens de cellen rechts van de rijen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79238\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-somme-automatique-pour-toute-la-table.png\" sizes=\"auto, \" srcset=\"\" alt=\"automatische som voor de hele tafel\" width=\"787\" height=\"344\"><\/figure><\/div><p> En gebruik vervolgens de sneltoets Alt+=, of gebruik de autosum-optie op het starttabblad. Het krijgt het totaal van alle kolommen en rijen. <\/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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-automatique.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\/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\/indirecte-som-2\/\">INDIRECT met SOM<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/totaal-accumuleert-1\/\">Cumulatief totaal<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/\">Som van de kwadraten<\/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-1682","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 ik autosum in Excel?<\/title>\n<meta name=\"description\" content=\"In deze tutorial leert u hoe u de autosum-functie van Excel kunt gebruiken om snel de som van de waarden te krijgen\" \/>\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\/autosom-1\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe gebruik ik autosum in Excel?\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leert u hoe u de autosum-functie van Excel kunt gebruiken om snel de som van de waarden te krijgen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/autosom-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:58:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.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\/autosom-1\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/autosom-1\/\",\"name\":\"\u25b7 Hoe gebruik ik autosum in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png\",\"datePublished\":\"2023-11-11T15:36:54+00:00\",\"dateModified\":\"2023-12-06T05:58:12+00:00\",\"description\":\"In deze tutorial leert u hoe u de autosum-functie van Excel kunt gebruiken om snel de som van de waarden te krijgen\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-1\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/autosom-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe gebruik ik autosum 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 ik autosum in Excel?","description":"In deze tutorial leert u hoe u de autosum-functie van Excel kunt gebruiken om snel de som van de waarden te krijgen","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\/autosom-1\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe gebruik ik autosum in Excel?","og_description":"In deze tutorial leert u hoe u de autosum-functie van Excel kunt gebruiken om snel de som van de waarden te krijgen","og_url":"https:\/\/exceladvisor.org\/nl\/autosom-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:58:12+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.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\/autosom-1\/","url":"https:\/\/exceladvisor.org\/nl\/autosom-1\/","name":"\u25b7 Hoe gebruik ik autosum in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/autosom-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/autosom-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png","datePublished":"2023-11-11T15:36:54+00:00","dateModified":"2023-12-06T05:58:12+00:00","description":"In deze tutorial leert u hoe u de autosum-functie van Excel kunt gebruiken om snel de som van de waarden te krijgen","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/autosom-1\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/autosom-1\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/autosom-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-derniere-cellule-sous-les-valeurs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/autosom-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe gebruik ik autosum 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\/1682","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=1682"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1682\/revisions"}],"predecessor-version":[{"id":2428,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1682\/revisions\/2428"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}