{"id":50219,"date":"2024-07-22T21:33:30","date_gmt":"2024-07-22T19:33:30","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=50219"},"modified":"2025-12-17T19:54:38","modified_gmt":"2025-12-17T18:54:38","slug":"como-adicionar-dois-numeros-no-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/how-to-add-two-numbers-in-google-sheets\/","title":{"rendered":"Como somar dois n\u00fameros no Planilhas Google: 3 m\u00e9todos diferentes"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

There are an infinity of reasons to add two numbers in Google Sheets. In this article we\u2019ll cover three different ways to achieve this.<\/span><\/p>\n

We will start with the SUMIF formula but we will move on to ADD and to arithmetic operators. Any of these functions are good, but still you should know the difference that separates them. This should help them Add two separate values using SUM.<\/span><\/p>\n

All three methods can be building blocks for more complicated formulas, they also have their pros and cons.<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_id=”sum” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Start with SUM formulas<\/span><\/h2>\n

SUM formulas are the bread and butter of adding values in Google Sheets. They allow you to sum numbers, cells or ranges. You can even set conditions to match in order to sum up values.\u00a0<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_id=”two” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Add two separate values using SUM<\/span><\/h3>\n

This function has a super simple syntax, all you need to do is give it values to sum. At its very basic it looks something like this:<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

=SUM(2)<\/span><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

This is a poor use of the formula, because it will just return the one value that was provided. But it goes to show just how straightforward it is.<\/span><\/p>\n

You can also pass cell coordinates as arguments.<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

=SUM(B1, B2, B3, B4)<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/07\/how-to-add-two-numbers-in-google-sheets_1.webp” alt=”How to add two numbers in google sheets 1″ title_text=”how-to-add-two-numbers-in-google-sheets_1″ align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Finally, to make the most of it, you can include ranges. This is where the formula really shines, as it allows you to sum all the values from columns and rows.<\/span>[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

=SUM(A1:A4)<\/span><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

This is often used to calculate totals as shown below.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/07\/how-to-add-two-numbers-in-google-sheets_2.webp” alt=”How to add two numbers in google sheets 2″ title_text=”how-to-add-two-numbers-in-google-sheets_2″ align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”sumif” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Conditional addition with SUMIF<\/span><\/h3>\n

Once you have mastered SUM, you can move on to its evolved forms: SUMIF and SUMIFS. Both of these formulas add two or more numbers in Google Sheets but only if certain conditions are met.<\/span><\/p>\n

For example, you could add only sales that exceed $100.<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

=SUMIF(B2:E2, “>100”)<\/span><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

This is what the resulting table would look like:<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/07\/how-to-add-two-numbers-in-google-sheets_3.webp” alt=”How to add two numbers in google sheets 3″ title_text=”how-to-add-two-numbers-in-google-sheets_3″ align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

SUMIFS works in much the same way, but you can apply as many conditions as you want.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/07\/how-to-add-two-numbers-in-google-sheets_4.webp” alt=”How to add two numbers in google sheets 4″ title_text=”how-to-add-two-numbers-in-google-sheets_4″ align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”add” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Add two values using ADD<\/span><\/h2>\n

The ADD function is similar to its SUM counterpart, but it has one major limitation: it adds exactly two numbers. This gives it two advantages:<\/span><\/p>\n