{"id":1719,"date":"2023-11-09T22:59:40","date_gmt":"2023-11-09T22:59:40","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/"},"modified":"2023-12-06T05:51:23","modified_gmt":"2023-12-06T05:51:23","slug":"som-van-kwadraten-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/","title":{"rendered":"Hoe vierkanten toevoegen in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2773886492\"><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>In Excel is er een specifieke functie die u kunt gebruiken om de som van de kwadraten van getallen in \u00e9\u00e9n cel te berekenen. Deze functie heet SOM. En verwijs naar een celbereik of voer waarden rechtstreeks in de functie in om het resultaat te krijgen.<\/p><h2 id=\"h-formula-to-get-the-sum-of-squares\" class=\"wp-block-heading\"> Formule om de som van de kwadraten te verkrijgen<\/h2><p> Hier zijn de stappen om deze formule te schrijven:<\/p><ol type=\"1\"><li> Typ (=) in een cel om de functie in te voeren.<\/li><li> Voer de (SUMQ) in en voer vervolgens de voorafgaande haakjes in.<\/li><li> Raadpleeg het bereik waar u de getallen heeft waarvan u de som van de kwadratenwaarde wilt krijgen.<\/li><li> Sluit de functie en druk op Enter om het resultaat te krijgen. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85889\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png\" sizes=\"auto, \" srcset=\"\" alt=\"som van de kwadraten\" width=\"635\" height=\"108\"><\/figure><\/div><p> Wanneer u op Enter drukt, krijgt u een uiteindelijke waarde, de som van het kwadraat van 25 en 25, omdat we twee getallen hebben in het bereik A1:B1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85890\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sommeq-en-somme-des-carres.png\" sizes=\"auto, \" srcset=\"\" alt=\"som-tot-som-kwadraat\" width=\"638\" height=\"293\"><\/figure><\/div><p> Ter verificatie kunnen wij een handmatige controle uitvoeren. Het kwadraat van 25 is 625, en aangezien we in beide cellen 25 hebben, zou dat 625 + 625 = 1250 moeten zijn. En dat is wat we in het resultaat zien. U kunt ook naar een bereik met meerdere getallen verwijzen zonder dat u zich zorgen hoeft te maken over het aantal cellen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85891\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-verification-manuelle-du-carre.png\" sizes=\"auto, \" srcset=\"\" alt=\"handmatige vierkante controle\" width=\"520\" height=\"424\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Opmerking:<\/strong> als u negatieve getallen gebruikt, krijgt u het resultaat altijd als een positief getal.<\/p><h2 id=\"h-use-a-simple-maths-formula\" class=\"wp-block-heading\"> Gebruik een eenvoudige wiskundige formule<\/h2><p> In plaats van de functie te gebruiken, kunt u een eenvoudige formule gebruiken met behulp van de caret-operator (^). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85892\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-formules-mathematiques-pour-additionner-les-carres.png\" sizes=\"auto, \" srcset=\"\" alt=\"wiskundige formule-in-som-kwadraten\" width=\"453\" height=\"290\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(A1^2,B1^2)<\/code><\/pre><p> Hier gebruikten we de SUM-functie, en bij elk getal gebruikten we de caret-operator (^) om eerst het kwadraat van dat getal te krijgen. Of u kunt ook een formule als deze schrijven:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1^2+B1^2<\/code><\/pre><p> Deze methoden hebben een beperkt gebruik. Als u dus een lange lijst met getallen heeft, kunt u beter de eerste methode gebruiken. <\/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-des-carres.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 volledige 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-1719","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>Hoe vierkanten toevoegen in Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een Excel-formule schrijft om de som van de kwadraten op twee verschillende manieren te berekenen. 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\/som-van-kwadraten-2\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe vierkanten toevoegen in Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een Excel-formule schrijft om de som van de kwadraten op twee verschillende manieren te berekenen. Laten we dit controleren...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:51:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.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\/som-van-kwadraten-2\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/\",\"name\":\"Hoe vierkanten toevoegen in Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png\",\"datePublished\":\"2023-11-09T22:59:40+00:00\",\"dateModified\":\"2023-12-06T05:51:23+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een Excel-formule schrijft om de som van de kwadraten op twee verschillende manieren te berekenen. Laten we dit controleren...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe vierkanten toevoegen 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":"Hoe vierkanten toevoegen in Excel? (Tutorial 2023)","description":"In deze zelfstudie leert u hoe u een Excel-formule schrijft om de som van de kwadraten op twee verschillende manieren te berekenen. 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\/som-van-kwadraten-2\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe vierkanten toevoegen in Excel? (Tutorial 2023)","og_description":"In deze zelfstudie leert u hoe u een Excel-formule schrijft om de som van de kwadraten op twee verschillende manieren te berekenen. Laten we dit controleren...","og_url":"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:51:23+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.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\/som-van-kwadraten-2\/","url":"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/","name":"Hoe vierkanten toevoegen in Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png","datePublished":"2023-11-09T22:59:40+00:00","dateModified":"2023-12-06T05:51:23+00:00","description":"In deze zelfstudie leert u hoe u een Excel-formule schrijft om de som van de kwadraten op twee verschillende manieren te berekenen. Laten we dit controleren...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-carres.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/som-van-kwadraten-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe vierkanten toevoegen 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\/1719","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=1719"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1719\/revisions"}],"predecessor-version":[{"id":2835,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1719\/revisions\/2835"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}