{"id":262313,"date":"2024-03-13T20:07:13","date_gmt":"2024-03-13T19:07:13","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=262313"},"modified":"2026-10-07T15:52:26","modified_gmt":"2026-10-07T13:52:26","slug":"como-subtrair-no-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/how-to-subtract-in-google-sheets\/","title":{"rendered":"Como subtrair no Google Sheets: f\u00f3rmula e exemplos"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>When you need to subtract values in Google Sheets, you have several options in terms of methods. In addition to using the minus sign, you can also use the MINUS and SUM functions to subtract. All three can be used by typing the values or using cell references, and they work with dates as well as with numbers. Additionally, you can combine these methods with the <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/arrayformula-google-sheets\/\">ARRAYFORMULA function<\/a> to subtract a number from a range of cells or subtract the values in one column from those in another column.<\/p>\n<p>In this guide, you will learn three different methods of subtracting values and cells in Google Sheets. You have step-by-step instructions on how to use the minus sign, the MINUS function, and the SUM function to subtract values. Additionally, you have examples using different types of values, like numbers and dates, as well as examples of subtracting multiple cells and entire columns.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;is-there-a-formula-in-google-sheets-to-s&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Is there a formula in Google Sheets to subtract?<\/h2>\n<p>The MINUS function in Google Sheets can be used to subtract one value from another. The function syntax is MINUS(value1, value2), where value2 will be subtracted from value1. For example, to subtract 3 from 9, you can use the following: MINUS(9, 3) = 6.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-subtract-numbers-or-cells-in-goog&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to subtract numbers or cells in Google Sheets: 3 ways<\/h2>\n<p>There are three main ways to subtract values in Google Sheets: the minus sign, the MINUS function, and the SUM function.<\/p>\n<h3>How to use the minus sign for subtraction?<\/h3>\n<p>Follow the steps below to subtract numerical values using the minus sign. You can also use cell references if you prefer.<\/p>\n<p><strong>1. <\/strong>In an empty cell, type the equal sign and the value from which you want to subtract (minuend).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-minuend.webp&#8221; alt=&#8221;How to subtract in Google Sheets \u2014 equal sign and the minuend 9.3 typed in a cell&#8221; title_text=&#8221;Equal sign and the minuend 9.3 typed in a cell&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Add the minus sign, then the value you want to subtract (subtrahend).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-minus-sign.webp&#8221; alt=&#8221;How to subtract in Google Sheets \u2014 subtraction formula =9.3-3.241 typed in the cell&#8221; title_text=&#8221;Subtraction formula =9.3-3.241 typed in the cell&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Press \u2018Enter\u2019 to see the result.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-minus-sign-result.webp&#8221; alt=&#8221;How to subtract in Google Sheets \u2014 result 6.059 from the minus sign&#8221; title_text=&#8221;Result 6.059 from the minus sign&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to use the MINUS function for subtraction?<\/h3>\n<p>Follow the steps below to use the MINUS function to subtract cells. In the following examples, I will use cell references instead of hardcoding the values into the formulas.<\/p>\n<p><strong>1. <\/strong>Type the values you want to subtract into separate cells.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-values.webp&#8221; alt=&#8221;Subtract in Google Sheets with MINUS \u2014 minuend and subtrahend typed in separate cells&#8221; title_text=&#8221;Minuend and subtrahend typed in separate cells&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Type the equal sign followed by the MINUS function in an empty cell.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-minus-function.webp&#8221; alt=&#8221;Subtract in Google Sheets with MINUS \u2014 MINUS function started in the result cell&#8221; title_text=&#8221;MINUS function started in the result cell&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Select the cell with the minuend, followed by a comma, then the cell with the subtrahend.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-minus-arguments.webp&#8221; alt=&#8221;Subtract in Google Sheets with MINUS \u2014 cells A2 and B2 added to the function&#8221; title_text=&#8221;Cells A2 and B2 added to the function&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Close the parenthesis and press \u2018Enter\u2019 to see the result.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-minus-function-result.webp&#8221; alt=&#8221;Subtract in Google Sheets with MINUS \u2014 result 6.059 from the MINUS function&#8221; title_text=&#8221;Result 6.059 from the MINUS function&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to use the SUM function for subtraction?<\/h3>\n<p>Follow the steps below to subtract cells with numerical values using the SUM function.<\/p>\n<p><strong>1. <\/strong>In an empty cell, type the equal sign followed by the SUM function.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-sum-function.webp&#8221; alt=&#8221;Subtract in Google Sheets with SUM \u2014 SUM function started below the MINUS result&#8221; title_text=&#8221;SUM function started below the MINUS result&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Select the cell with the minuend as the first parameter, followed by a comma.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-sum-minuend.webp&#8221; alt=&#8221;Subtract in Google Sheets with SUM \u2014 minuend cell added as the first parameter&#8221; title_text=&#8221;Minuend cell added as the first parameter&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>After the comma, type in the minus sign before the subtrahend and close the parenthesis.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-sum-negative-subtrahend.webp&#8221; alt=&#8221;Subtract in Google Sheets with SUM \u2014 minus sign added before the subtrahend cell&#8221; title_text=&#8221;Minus sign added before the subtrahend cell&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Press \u2018Enter\u2019 to see the result.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-sum-result.webp&#8221; alt=&#8221;Subtract in Google Sheets with SUM \u2014 result 6.059 from the SUM function&#8221; title_text=&#8221;Result 6.059 from the SUM function&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-do-i-subtract-dates-in-google-sheets&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How do I subtract dates in Google Sheets?<\/h2>\n<p>You can subtract dates using the methods shown above to get the <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/calculate-the-differences-between-dates-in-google-sheets\/\">difference in days<\/a>. However, you can also <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/datedif-formula-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">use the DATEDIF function<\/a> to access more options in terms of units.<\/p>\n<p><strong>1. <\/strong>In separate cells, type the end date and the start date you want to subtract from it.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-dates.webp&#8221; alt=&#8221;Subtract dates in Google Sheets \u2014 end date and start date typed in separate cells&#8221; title_text=&#8221;End date and start date typed in separate cells&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>In an empty cell, type the equal sign and select the cell with the end date, which is the minuend in this case.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-end-date.webp&#8221; alt=&#8221;Subtract dates in Google Sheets \u2014 equal sign and the end date cell in the formula&#8221; title_text=&#8221;Equal sign and the end date cell in the formula&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Add the minus sign and select the start date as the subtrahend.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-start-date.webp&#8221; alt=&#8221;Subtract dates in Google Sheets \u2014 start date cell subtracted from the end date&#8221; title_text=&#8221;Start date cell subtracted from the end date&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Press \u2018Enter\u2019 to see the result.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-dates-minus-sign.webp&#8221; alt=&#8221;Subtract dates in Google Sheets \u2014 764 days returned by the minus sign&#8221; title_text=&#8221;764 days returned by the minus sign&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5. <\/strong>The MINUS function can also be used to get the difference between the dates.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-dates-minus-function.webp&#8221; alt=&#8221;Subtract dates in Google Sheets \u2014 the same 764 days returned by the MINUS function&#8221; title_text=&#8221;The same 764 days returned by the MINUS function&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6. <\/strong>The SUM function is the third method you can use to subtract these dates.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-dates-sum.webp&#8221; alt=&#8221;Subtract dates in Google Sheets \u2014 the same 764 days returned by the SUM function&#8221; title_text=&#8221;The same 764 days returned by the SUM function&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7. <\/strong>Finally, you can also use DATEDIF for this purpose.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-dates-datedif.webp&#8221; alt=&#8221;Subtract dates in Google Sheets \u2014 DATEDIF returning the difference in days&#8221; title_text=&#8221;DATEDIF returning the difference in days&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-do-i-subtract-multiple-cells-in-goog&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How do I subtract multiple cells in Google Sheets?<\/h2>\n<p>To subtract a number from a range of cells, use the MINUS function together with the ARRAYFORMULA function. Type the ARRAYFORMULA function, followed by the MINUS function. Select the range of cells as the first parameter, followed by a comma and the value or cell reference you want to subtract.<\/p>\n<p><strong>1. <\/strong>Type the values you want to use as minuends into separate cells. In another cell, type the subtrahend.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-multiple-cells.webp&#8221; alt=&#8221;Subtract multiple cells in Google Sheets \u2014 column of minuends and a single subtrahend&#8221; title_text=&#8221;Column of minuends and a single subtrahend&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>In an empty cell, type the ARRAYFORMULA function, followed by the MINUS function.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-arrayformula-minus.webp&#8221; alt=&#8221;Subtract multiple cells in Google Sheets \u2014 ARRAYFORMULA and MINUS started in the result cell&#8221; title_text=&#8221;ARRAYFORMULA and MINUS started in the result cell&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Select the cells containing the minuend values, followed by a comma.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-minuend-range.webp&#8221; alt=&#8221;Subtract multiple cells in Google Sheets \u2014 minuend range A2:A9 added to MINUS&#8221; title_text=&#8221;Minuend range A2:A9 added to MINUS&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Select the cell with the subtrahend.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-subtrahend-cell.webp&#8221; alt=&#8221;Subtract multiple cells in Google Sheets \u2014 subtrahend cell B2 added to MINUS&#8221; title_text=&#8221;Subtrahend cell B2 added to MINUS&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5. <\/strong>Close both parentheses and press \u2018Enter\u2019 to see the results.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-multiple-cells-result.webp&#8221; alt=&#8221;Subtract multiple cells in Google Sheets \u2014 every minuend reduced by the subtrahend&#8221; title_text=&#8221;Every minuend reduced by the subtrahend&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-do-i-subtract-columns-in-google-shee&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How do I subtract columns in Google Sheets?<\/h2>\n<p>Follow the steps below to subtract the values in one column from the values in another column with one formula by combining the minus sign or the MINUS function with the ARRAYFORMULA function.<\/p>\n<p><strong>1. <\/strong>Open the spreadsheet with your columns of values.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-columns.webp&#8221; alt=&#8221;Subtract columns in Google Sheets \u2014 minuend and subtrahend columns ready to subtract&#8221; title_text=&#8221;Minuend and subtrahend columns ready to subtract&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>In an empty cell, type the ARRAYFORMULA function followed by the MINUS function.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-arrayformula-minus-2.webp&#8221; alt=&#8221;Subtract columns in Google Sheets \u2014 ARRAYFORMULA and MINUS started in the result column&#8221; title_text=&#8221;ARRAYFORMULA and MINUS started in the result column&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Select the column with the minuends followed by a comma.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-minuend-column.webp&#8221; alt=&#8221;Subtract columns in Google Sheets \u2014 minuend column A2:A14 added to MINUS&#8221; title_text=&#8221;Minuend column A2:A14 added to MINUS&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Select the column with the subtrahends.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-subtrahend-column.webp&#8221; alt=&#8221;Subtract columns in Google Sheets \u2014 subtrahend column B2:B14 added to MINUS&#8221; title_text=&#8221;Subtrahend column B2:B14 added to MINUS&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5. <\/strong>Close both parentheses and press \u2018Enter\u2019 to see the results.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/subtract-google-sheets-columns-result.webp&#8221; alt=&#8221;Subtract columns in Google Sheets \u2014 column of results from a single formula&#8221; title_text=&#8221;Column of results from a single formula&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>There are different methods you can use to subtract values in Google Sheets: the minus sign, the MINUS function, and the SUM function. You know you can type the values directly into the formula or use references to the cells containing your values. You can also use these methods to subtract full dates to get the difference in days.<\/p>\n<p>However, if you need more unit options, you also know you can <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/datedif-formula-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">use the DATEDIF function<\/a> instead. Finally, you also know that by combining any of these methods with the ARRAYFORMULA function, you can subtract a value from multiple cells at the same time or subtract the values in one column from those in another column using a single formula.<\/p>\n<p>For the other basic operations, see how to <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/how-to-add-two-numbers-in-google-sheets\/\">add two numbers<\/a> and how to <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-divide-in-google-sheets\/\">divide in Google Sheets<\/a>.<\/p>\n<p>To scale a whole column by one number or multiply two columns row by row, here&#8217;s <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-multiply-in-google-sheets\/\">how to multiply in Google Sheets<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Subtrair no Google Sheets \u00e9 f\u00e1cil e r\u00e1pido com a f\u00f3rmula certa. Veja como subtrair no Google Sheets e simplificar a an\u00e1lise dos seus dados.<\/p>","protected":false},"author":2,"featured_media":262342,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[],"class_list":["post-262313","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=262313"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262313\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/262342"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=262313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=262313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=262313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}