{"id":146903,"date":"2021-01-04T13:24:37","date_gmt":"2021-01-04T10:24:37","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-calculate-the-sum-of-squares-in-excel\/"},"modified":"2021-01-04T13:24:37","modified_gmt":"2021-01-04T10:24:37","slug":"how-to-calculate-the-sum-of-squares-in-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-the-sum-of-squares-in-excel\/","title":{"rendered":"#How to Calculate the Sum of Squares in Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6affb1482ef37\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6affb1482ef37\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-the-sum-of-squares-in-excel\/#Finding_the_Sum_of_Squares_for_Multiple_Cells\" >Finding the Sum of Squares for Multiple Cells<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-the-sum-of-squares-in-excel\/#Finding_the_Sum_of_Squares_for_Just_a_Few_Cells\" >Finding the Sum of Squares for Just a Few Cells<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Calculate the Sum of Squares in Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-435491 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/xstock-lede-microsoft-office_excel-1.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.Bi7kk-HHRf.png\" alt=\"A Microsoft Excel Logo on a gray background\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Finding the sum of squares in Microsoft Excel can be a repetitive task. The most obvious formula requires a lot of data entry, though there\u2019s a lesser-known option that gets you to the same place.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Finding_the_Sum_of_Squares_for_Multiple_Cells\"><\/span>Finding the Sum of Squares for Multiple Cells<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Start a new column anywhere in an Excel spreadsheet and label it. It\u2019s here that we\u2019ll output the solution of our squares. The squares don\u2019t have to be next to each other, nor does the output section; it can be anywhere on the page.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-701272\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/11\/xnew-column.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.mtwH-XizL_.png\" alt=\"add a new column\" width=\"650\" height=\"301\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Type the following formula into the first cell in the new column:<\/p>\n<pre>=SUMSQ(<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-701264\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/11\/xsumsq-formula.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.bqLxAXmyWz.png\" alt=\"sumsq formula excel\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>From here you can add the letter and number combination of the column and row manually, or just click it with the mouse. We\u2019ll use the mouse, which autofills this section of the formula with cell A2.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-701265\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/11\/xsumsq-a2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.mjQzl4YXkd.png\" alt=\"add cell a2\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Add a comma and then we\u2019ll add the next number, from B2 this time. Just type in B2 to the formula, or click the <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ropriate cell to autofill it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-701266\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/11\/xsumsq-b2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.j44BTsj5IK.png\" alt=\"add cell b2\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Close the parenthesis and press \u201cEnter\u201d on the keyboard to display the sum of both squares. Alternatively, if you can keep going here, adding additional cells by separating each with a comma within the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-701267\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/11\/xsumsq-close-parenthesis.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.u5ULvicO12.png\" alt=\"close parenthesis\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To apply the formula to additional cells, look for the small filled square in the cell that contains the solution to our first problem. In this example, it\u2019s C2.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-701268\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/11\/xbox.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.elVRn1Rcde.png\" alt=\"find box\" width=\"650\" height=\"299\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click the square and drag it down to the last row of number pairs to automatically add the sum of the rest of the squares.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-701269\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/11\/xdrag.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.ncnsIaUJ58.png\" alt=\"drag to bottom\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Finding_the_Sum_of_Squares_for_Just_a_Few_Cells\"><\/span>Finding the Sum of Squares for Just a Few Cells<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In our \u201cSum of Squares\u201d column we created in the previous example, C2 in this case, start typing the following formula:<\/p>\n<pre>=SUM((A2)^2,(A3)^2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-701270\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/11\/xsimple-formula.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.uenfGAwR03.png\" alt=\"simple formula for sum of squares\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Alternatively, we can just add the numbers instead of the cells to the formula, as either way gets us to the same place. That formula looks like this:<\/p>\n<pre>=SUM((9)^2, (29)^2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-701271\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/11\/xsimple-formula2.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.WFs1hV0-46.png\" alt=\"simple formula for sum of squares\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can alter these formulas as needed, changing the cells, adding additional numbers, or finding the sum of squares that aren\u2019t even in your workbook, for example. And while it\u2019s easier to follow along with the above tutorial, using the SUMSQ formula, to find the solution for multiple squares, it\u2019s often easier to just type out a quick formula like this if it\u2019s not something you\u2019ll be repeating throughout the workbook.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/701263\/how-to-calculate-the-sum-of-squares-in-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Calculate the Sum of Squares in Excel&#8221; Finding the sum of squares in Microsoft Excel can be a repetitive task. The most obvious formula requires a lot of data entry, though there\u2019s a lesser-known option that gets you to the same place. Finding the Sum of Squares for Multiple Cells Start a new&#8230;<\/p>\n","protected":false},"author":1,"featured_media":146904,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/thumbcache\/2\/200\/2144ab7a8e4ef0c005417526e2a219c4\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-146903","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/146903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=146903"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/146903\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/146904"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=146903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=146903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=146903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}