How To Do Sum In Google Sheets

To perform a sum in Google Sheets, use the formula “=SUM(range)” where range represents the cells that you want to include in the sum. The cumulative total of the specified range.

In today’s digital age, spreadsheets have become an indispensable tool for organizing and analyzing data. Google Sheets, part of the Google Workspace suite, offers a robust set of features that can simplify even the most complex tasks. One such fundamental operation is calculating the sum of values within a spreadsheet. Whether you’re a student, a business professional, or simply looking to streamline your personal finances, mastering the art of summing in Google Sheets can save you time and effort. In this blog post, we will explore various methods and tips to help you become proficient in performing sums in Google Sheets, enabling you to unleash the full potential of this powerful spreadsheet software.

How To Do Sum In Google Sheets: Step-by-Step


Step 1: Open Google Sheets,

Once you’re in your Google Sheets, locate and open the specific sheet where you want to calculate the sum. In case you don’t have the desired sheet in existence, simply create a new one.

Next Step

Step 2: Input Data,

Now you will have to enter the numbers that you wish to sum up into your Google Sheet. If you already have data, you can skip this step. Google Sheets allows you to conveniently input numerical values for the purpose of performing summation calculations.

Next Step

Step 3: Choose cell for output,

Choose any cell in the same column or row where you want the sum result to be displayed. This cell will be the final destination for the total sum of the numbers you wish to add together.

Next Step

Step 4: Begin formula with ‘=’ sign,

Starting any formula in Google Sheets is crucial, as it allows you to perform calculations and retrieve data efficiently. To initiate a formula, simply click on the desired output cell and type the “=” sign, unleashing a world of powerful spreadsheet functionality.

Next Step

Step 5: Type SUM function and select range,

After ‘=’, you have to type ‘SUM(‘, and then select the range of cells containing the numbers you want to sum. You can do this by clicking and dragging over the required cells. The selected range will automatically populate in the formula, allowing you to quickly calculate the total sum.

Next Step

Step 6: Close formula and press Enter,

To close the formula correctly, simply add the closing bracket ‘)’ at the end, like this: ‘=SUM(A1:A10)’. Then press Enter to apply the formula.

Next Step

Step 7: View Result,

After pressing Enter, the sum function will calculate the sum of the selected values and the result will be immediately displayed in the designated output cell.


In conclusion, learning how to do sum in Google Sheets can greatly enhance your productivity and make data analysis more efficient. By understanding the various functions and techniques available, you can easily perform calculations on your spreadsheet and gain valuable insights. Whether you’re a student, professional, or simply using Google Sheets for personal tasks, knowing how to use the sum formula will prove to be a valuable skill. So, start practicing and mastering this function, and unlock the full potential of Google Sheets!

Table of Contents