# How to sum column values in Google Sheets

Google Sheets is probably the most handy and widely used online software tool to manipulate and analyse numeric data. It has many functions and tools to do all calculations ranging from simple to complex level.

When we talk about adding a whole column in Google Sheets or Excel then it could mean two things.

• Sum all the values in a particular column
• Add or insert a new column in the sheet

In today’s tutorial we’ll learn both methods one by one.

## Case 1: Sum all the values of a particular column

This is probably the most common requirement and most frequently used tool of Google Sheets. So let’s learn it how to add all values contained in a cell by using the following methods;

• Using Auto-Sum from Editing Group on Home Tab or Auto-Sum Shortcut Key

(Add successive values of the same column only)

• Writing a formula to get the sum of adjacent or non-adjacent values present anywhere in the sheet

Consider the following data set containing the sales data from various cities of various products.

## Method 1 – Using AutoSum to add a column (sum all values)

Using this method we can add the values in the column very quickly and without much effort. However, the downside of using this tool is that we can only add the values which are adjacent to each other in a column. If there are non-numeric values in between the numeric values then this method won’t help you. We’ll take care of this issue in the second method.

So to use the first method follow along these steps and calculate the total sales.

## Step 1 – Use Auto-Sum Option

• Select all the adjacent cells in the column that you want to add.
• On the Menu bar go to the extreme right and click on sigma icon Sum and then click on the SUM option.
• Google will write the formula to sum all above values of the column automatically. You just need to press enter to finalize the calculation. The sum of all the values present above will be calculated then.