{"id":380216,"date":"2021-12-12T22:00:25","date_gmt":"2021-12-12T19:00:25","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-subtract-numbers-in-google-sheets\/"},"modified":"2021-12-12T22:00:25","modified_gmt":"2021-12-12T19:00:25","slug":"how-to-subtract-numbers-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-subtract-numbers-in-google-sheets\/","title":{"rendered":"#How to Subtract Numbers in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 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-6a2e0bcc27b10\" 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-6a2e0bcc27b10\" 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-subtract-numbers-in-google-sheets\/#Use_the_MINUS_Function\" >Use the MINUS Function<\/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-subtract-numbers-in-google-sheets\/#Use_the_Minus_Sign\" >Use the Minus Sign<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-subtract-numbers-in-google-sheets\/#Use_the_SUM_Function\" >Use the SUM Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-subtract-numbers-in-google-sheets\/#Create_Subtraction_Equations\" >Create Subtraction Equations<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Subtract Numbers in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Adding numbers in Google Sheets is one of the most basic calculations. Just like Excel, you can use the SUM function. But what about subtracting numbers? With Google Sheets, you have a few different ways to subtract values.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_MINUS_Function\"><\/span>Use the MINUS Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Unlike Microsoft Excel, Google Sheets has a function for subtraction. The function is <code>MINUS<\/code> and it works with both numbers and cell references. The syntax for the formula is <code>MINUS(value1, value2)<\/code> where both arguments are required.<\/p>\n<p>To subtract numbers, such as 20 minus 15, you would enter the following formula and press Enter.<\/p>\n<pre>=MINUS(20,15)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770771\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/MinusNumbers-GoogleSheetsSubtract.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Subtract numbers with the MINUS function\" width=\"540\" height=\"200\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To subtract values within cells, like <code>A2<\/code> minus <code>A3<\/code>, you would enter this formula and press Enter.<\/p>\n<pre>=MINUS(A2,A3)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770770\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/MinusCellReferences-GoogleSheetsSubtract.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Subtract cell values with the MINUS function\" width=\"540\" height=\"280\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" 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=\"Use_the_Minus_Sign\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Use the Minus Sign<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Along with the <code>MINUS<\/code> function, you can simply <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/757264\/how-to-subtract-numbers-in-microsoft-excel\/\">enter a minus sign for the numbers or cell references you want to subtract.\u00a0The advantage to this method is that you don\u2019t have to include the values in parentheses.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Subtract Numbers in Microsoft Excel<\/em><\/strong><\/p>\n<p>To subtract numbers, such as 20 minus 15, you would enter the following formula and press Enter.<\/p>\n<pre>=20-15<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770772\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/MinusSignNumbers-GoogleSheetsSubtract.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Subtract numbers with the minus sign\" width=\"460\" height=\"200\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To subtract values within cells, like <code>A2<\/code> minus <code>A3<\/code>, you would enter this formula and press Enter.<\/p>\n<pre>=A2-A3<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770773\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/MinusSignCellReferences-GoogleSheetsSubtract.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Subtract cell values with the minus sign\" width=\"470\" height=\"280\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" 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=\"Use_the_SUM_Function\"><\/span>Use the SUM Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019re accustomed to using the <code>SUM<\/code> function and prefer to stick with it, you can use it to subtract numbers as well as add them. You simply use the function along with the minus sign described above.<\/p>\n<p>To subtract the numbers 20 minus 15 using <code>SUM<\/code>, you would enter the following and press Enter.<\/p>\n<pre>=SUM(20-15)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770774\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SumMinusSignNumbers-GoogleSheetsSubtract.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Subtract numbers with the SUM function\" width=\"500\" height=\"195\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To subtract the values in cells <code>A2<\/code> and <code>A3<\/code>, you would enter this formula and press Enter.<\/p>\n<pre>=SUM(A2-A3)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770775\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SumMinusSignCellReferences-GoogleSheetsSubtract.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Subtract cell values with the SUM function\" width=\"500\" height=\"275\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" 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=\"Create_Subtraction_Equations\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Create Subtraction Equations<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Not every calculation you need is as simple as A minus B. For instance, you might want to add a few numbers and then subtract others. Using the above functions along with operators like the minus and plus signs, you can <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/436537\/how-to-use-the-equation-editor-in-google-docs\/\">create the equation you need. Let\u2019s look at a few examples.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use the Equation Editor in Google Docs<\/em><\/strong><\/p>\n<p>You can use the <code>MINUS<\/code> function to subtract your values and then multiply the result. As an example, we\u2019ll subtract the values in cells <code>A2<\/code> and <code>A3<\/code> and then multiply the result by 10. You would enter the following and hit Enter.<\/p>\n<pre>=MINUS(A2,A3)*10<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770776\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/MinusWithMultiply-GoogleSheetsSubtract.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Use the MINUS function with multiply\" width=\"580\" height=\"280\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Similarly, you can use the minus sign with cell references or numbers and then add a value. With this formula, we subtract 10 from 25 and add 15 to the result.\u00a0Note that in this case you would use parentheses with the minus sign to perform that calculation first.<\/p>\n<pre>=(25-10)+15<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770777\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SubtractWithAdd-GoogleSheetsSubtract.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Use the minus sign with addition\" width=\"500\" height=\"190\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For one more example, we\u2019ll use the <code>SUM<\/code> function to add the range of values in cells <code>A2<\/code> through <code>A5<\/code> and then subtract the value in cell <code>A6<\/code>.<\/p>\n<pre>=SUM(A2:A5)-A6<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-770778\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SumWithSubtract-GoogleSheetsSubtract.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Use the SUM function with subtraction\" width=\"580\" height=\"400\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Looking for additional help with formulas and equations? Take a look at how to divide numbers in Google Sheets or how to see basic calculations without creating formulas at all.<\/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\/770763\/how-to-subtract-numbers-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Subtract Numbers in Google Sheets&#8221; Adding numbers in Google Sheets is one of the most basic calculations. Just like Excel, you can use the SUM function. But what about subtracting numbers? With Google Sheets, you have a few different ways to subtract values. Use the MINUS Function Unlike Microsoft Excel, Google Sheets has&#8230;<\/p>\n","protected":false},"author":1,"featured_media":380217,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-380216","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\/380216","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=380216"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/380216\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/380217"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=380216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=380216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=380216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}