LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Google Sheets Formulas

How to Use SUM Function in Google Sheets

In this article, we will explain how to add numbers in some cells or in a selected range or array with a formula called “SUM.”

What is the SUM function in Google Sheets?

The SUM function in Google Sheets calculates the sum of a range of cells. It takes a cell, range, or array as arguments and returns the sum of the values in the specified area. The SUM function is beneficial whenever you need to calculate the total of a range of cells quickly. It is handy when you have a large data set and want a quick data summary.

For example, if you have a spreadsheet containing a list of expenses and want to know the total amount spent, you can use the SUM function to add up all the values in the "Amount" column. 

Why is the SUM formula beneficial in Google Sheets?

Using the SUM function in Google Sheets can be beneficial for several reasons:

  • Accuracy: The SUM function in Google Sheets ensures accurate calculations. It performs the addition operation automatically and eliminates the possibility of human errors that may occur when adding up numbers manually. This helps prevent mistakes in calculations and ensures accurate results.

  • Efficiency: The SUM formula is designed to handle calculations on a large scale and across multiple cells or ranges. This makes it efficient for adding up numbers in columns, rows, or other ranges of cells, especially when dealing with large datasets. It can save time and effort compared to manual calculations, especially when dealing with complex or extensive data.

  • Dynamic calculations: The SUM function in Google Sheets is dynamic. If new numbers are added to the range or existing numbers are modified, the sum will automatically update if it is properly inserted. This makes it convenient for handling changing data or scenarios where calculations need to be adjusted on the fly. It saves the hassle of manually updating calculations every time data changes.

  • Collaboration: The SUM function is compatible with Google Sheets' collaborative features, allowing multiple users to work on the same sheet simultaneously. This makes it convenient for teams or groups to collaborate on calculations, share data, and review or verify calculations in real-time.

In summary, using the SUM function in Google Sheets can provide benefits such as accuracy, efficiency, dynamic calculations, and collaboration, making it a valuable tool for various tasks that involve adding up numbers and calculating totals in a spreadsheet environment.

Save hours formatting your next financial spreadsheet!
100+ templates, all free to use.
Free Spreadsheet Templates

How to use the SUM formula in Google Sheets

  • Select a cell to show an aggregated number of values.

  • In the chosen cell, type “=SUM(” and select cells or a range you want to sum up, or by choosing from a list of functions (Go to the “Insert” tab, move to the “Function”, and select “SUM” function.

  • Then, you can manually type in values or input cells or a range by cell reference.

  • Press the “Enter” key on your keyboard.

insert the SUM function from the menu bar
How to insert the SUM function from the menu bar in Google Sheets

The general syntax of the SUM formula is as follows:

=SUM(value1, [value2, …])

value1: This is the first number(s) to be added up

value2 (Optional): You can insert arguments up to thirty

How to add up cells in Google Sheets

If you want to sum up a couple of numbers without any functions, you can calculate the results, using the plus signs in the screenshot above. To add numbers in cells B2, C2, and D2, and show the result in cell E2, you can type “=B2+C2+D2” by manually inputting or selecting cell B2 and pressing the “+” mark and do the same for other cells (C2 and D2).

You can receive the same return by using the SUM function. To do so, insert the SUM formula and select three cells you want to add, separating them with commas, as shown in the picture below.

sum up values in cells  
How to sum up values in cells in Google Sheets with examples

How to add rows in Google Sheets

As described above, you can select a row or rows as argument(s) in the SUM formula.

If you want to sum up numbers in Row 6 (from Columns B to D), you can define the formula as follows: 

=SUM(B6:D6)

If you want to sum multiple rows, for instance, Row 8, Row 9, and Row 10 (again, from Columns B to D), you can create the formula below.

=SUM(B8:D8, B9:D9, B10:D10)

sum up values in a row or multiple rows
How to sum up values in a row or multiple rows in Google Sheets

Level up your Google Sheets skills with our FREE LiveFlow Academy
Basic and intermediate classes live now! Earn your certificate today.
Enroll in LiveFlow Academy

How do I make columns added up in Google Sheets?

As described above, you can select a column or multiple columns as parameter(s) in the SUM function. Enter the arguments similar to when you add up rows, which is described above.

When you add up values in a column, you can select a range in a column as the following formula.

=SUM(B12:B14)

As another example, assume you want to sum up numbers in multiple columns, Column B (from Row 16 to 18), Column C (from Row 16 to 18), and Column E (from Row 16 to 18). You can define the formula as follows:

=SUM(B16:B18,C16:C18,D16:D18)

sum up numbers in a column or multiple columns 
How to sum up numbers in a column or multiple columns in Google Sheets

How to sum up values in an array in Google Sheets

Imagine you need to aggregate figures in a 3x3-sized array. When you sum up numbers in an array (or arrays), you can use the SUM function. For example, if you want to calculate the total number of values in the array of B20:D22, the SUM function would look like the one below.

=SUM(B20:D22)

How to calculate the total figure
How to compute the total value of numbers in an array with the SUM formula in Google Sheets

How do you add up numbers automatically in Google Sheets?

If you in advance select a range including cells that you will fill in with numbers later, when you input any numbers in any cells in the selected range, all numbers are summed up automatically by the SUM formula. For example, let’s assume that you set the SUM formula “=SUM(B20:D22)”, and all cells in the range are blank.

If you input any figures in the range later, the numbers typed in are automatically summed up, and you can see the aggregated number in the cell you input the formula (cell E20 in this example). 

insert the SUMIF function from the menu bar 
How to calculate the total figure of values automatically in Google Sheets

Turn Quickbooks Online data into a Google Sheets dashboard
100+ templates, update automatically, totally secure!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.