Sign in Subscribe

Google Sheets Tips

How to sum a column in Google Sheets?

4 operations are pretty easy when working with Google Sheets. You can operate with two cells, as well as with more than two. In this article, we will go a little further and look at how to get the sum of an entire row.

How to Sum a Column Using Formula?

Summing a column can be done by using the formula icon, and also by typing it manually. Let's write it manually first.

How to Sum a Column by Manually Writing a Formula?

What is the syntax of the sum function,

=SUM(value1,value2..)

The formula to get the sum of a column:

Come to the column where you want the total to be written
Write -> =SUM()

Select the cells you want the total to include in the parentheses. You can also type this manually -> (A1:A10)

Example: Since I want to sum column A, it is written as =SUM (A1:A10).

(I selected cells; cell ranges are written automatically)

I typed the formula manually. You can also access the formula from the toolbar.

Select the column you want to get the total of
Go to toolbar
Click the formula icon
Choose → Σ

After this process, the result is automatically written under the column you have chosen.

The SUM operation we made was valid for the column we selected. If I add a new cell, will it be included in the total? The answer is yes!

This applies to the addition we do with both methods. If a new cell comes in between, it refreshes the result. The same applies when the cell is deleted, subtracting that row from the total.

If there are columns to be added more than one, we can pull the cell in which we typed the formula to the right or left, so that it gets the sum in the other columns. Other columns do not need to have the same number of rows. Let's assume column A is 10 rows then column B is 4 rows. You just need to pull the formula bar to wherever you want.

You can refer to these articles for other mathematical operations that we can do with columns.

For the multiplication->"How to multiply in Google Sheets?"

For the subtract->"How to subtract in Google Sheets?"

Read next

How to add a checkbox in Google Sheets?

How to add a checkbox in Google Sheets?

Tick boxes are often used in making binary choices or task lists. We can easily use tick boxes in Google Spreadsheets. When the tick box is checked, it is saved as yes; if it is left blank, our table will detect it as no. Let's get into it. How to

How to create a pivot table in Google Sheets?

How to create a pivot table in Google Sheets?

The pivot table eliminates the complexity of the data by making it more categorical. You can make your multi-column table more readable. Do not assume you will have a hard time categorizing it. If you have decided to make a pivot table, Google Spreadsheets has already suggestions for you. If

How to delete rows in Google Sheets?

How to delete rows in Google Sheets?

One of the great things about working with Google Sheets is that sheets can be easily shared with others. We, however, often come across a missing line on the shared pages; or we may want to get rid of some rows while working on our page. So what to do

How to filter in Google Sheets?

How to filter in Google Sheets?

Working with Google Spreadsheets, we encounter many situations requiring us to search, and our data can be very large. Do not waste your time looking for something at the large table. Filters take care of this for us. Let's start with the menu first. How to filter using the menu?

How to indent text in Google Sheets?

How to indent text in Google Sheets?

In Google Sheets, the text is italicized to the left, and numbers are italicized to the right. When we work with texts, we may want a list view rather than the normal view. Categorizing and indenting texts provides ease of reading. However, there is no shortcut for this function in

How to remove duplicates in Google Sheets?

How to remove duplicates in Google Sheets?

Duplicate entries or duplicate rows happen when your data appears more than once. They must be found and removed before any data analysis is performed. Imagine you have two instances of the same customer transaction in your database. When you summarize your data, you will make decisions based on inaccurate

How to save Google Sheets?

How to save Google Sheets?

One of the joys of working with Google Spreadsheets is that what we do is saved. This feature can be pretty useful if you tend to forget saving like me. Google Sheets gets the job done for us, therefore you do not have to go to the menu and save

How to set print area in Google Sheets?

How to set print area in Google Sheets?

Print area features in Google Sheets make our job a lot easier. We can quickly add a printing area with its easy-to-use options. Let's first analyze how to use the print area and then the formatting part. We can access the printing area from the menu as well as from

How to split cells in Google Sheets?

How to split cells in Google Sheets?

In Google Sheets, you may need to split the text for analysis. In Google Sheets, you may need to split the text for analysis. Let's explain this with an example. Let's say we have a table with a phone list. We want to know which subscription is being used. For

How to make graphs in Google Sheets?

How to make graphs in Google Sheets?

The larger the data, the harder it is to interpret. Graphs help us to get rid of this problem. Creating charts in Google Spreadsheets is pretty easy. Let's take a look at the content before moving on to the instructions. What are graphics used for? The types of charts we