How to Sum a Row or Column in Google Sheet

  • Reading time:2 mins read
  • Post category:Functions
  • Post comments:0 Comments

Performing a sum operation of cell range, rows, columns is the most frequently performed task during any data analysis work.

Google sheets provides us with SUM() Function specifically for this operation. Let’s understand how to use SUM Function in Google Sheets.

Understanding SUM Function

Syntax and Parameter Definition

= SUM(value1, [value2, ...])
  1. value1: First Number or Cell Range to Add
  2. value2: OPTIONAL- Additional Number or Cell Range to add in the Sum Operation

Note:

  1. You can add as many “values” as you want
  2. You can add static values or cell references
  3. Non-Numeric or Missing values will be ignored during a addition
  4. The cell in which output of SUM is stored should not be referenced inside the Formula.

Expected Output

As indicated before SUM Function will add-up all types of numeric values presented to it in the form of static numbers, cell reference or cell ranges. All Non-numeric inputs will be ignored(Row 6).

Add a Column(Whole or Partial) using SUM Function

By this time I am sure that you would have got a gist of working SUM Function. Now lets see how can we use it to Sum Entire Columns.

Partial SUM

In the below example we have applied SUM Function to the range X:Y and we have the output as expected.

Sum ROW using SUM Function

Remember that since we have reference cell range, hence the output of the SUM Function is dynamic as well. If we were to say change the value of B7 to 10 , the output would get updated as well.

Column Total using SUM

Adding Entire Column

Using a minor tweak to the formula discussed above we can get the sum of entire column very easily. Just use the formula SUM(B:B) and we are good. Don’t worry about any missing cells as they would be not even considered in the calculation.

Add a Row using SUM Function

Using similar method discussed above we can calculate row level sum as well. Again, we’ll not go again in a lot of detail. Below example should suffice.

ROW Total using SUM

That’s it on this topic. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply