How to add a column in Google Sheets [Mobile Apps & Desktop]

Device links

• Android
• iPhone
• Chromebook
• Mac
• windows
• Device missing?

Without a doubt, Google Sheets is part of the modern business starter package. This useful application allows you to keep your data organized, clear and up to date at all times. And it’s pretty easy to use!

There are many things you can do with the data you enter in your columns and rows. Many formulas available can save you time and help you focus on the core of your tasks instead of wasting time calculating things manually.

If your burning question right now is how to sum a column in Google Sheets, this article will give you all the answers.

What is the formula to add a column in Google Sheets?

Google Sheets uses fairly simple formulas to perform any math you may need. Sometimes you may even have more than one option.

The simplest formula to add a column is ADDITION function. This commonly used built-in function allows you to quickly add any number of numbers.

For example, you have a column of five numbers that you want to add and they are located in cells A1 to TO 5. The formula will look like this:

=SUM (A1:A5)

He = The sign is an element that you should always use with formulas in Google Sheets because it means that you are about to enter a function. After this, you must enter the name of the function, which in this case is ADDITION. Add all the values ​​in the range you will designate.

The parentheses following the function name tell the program which cells should be included in the formula. In this case, you will include the column letter and cell numbers in parentheses to mark which ones you want to add.

To use this formula, you must type it in the cell where you want to see the results. When you’re done, press Get into and the sum will be displayed in the designated field.

Note that if you change the data in the cells to which you applied the formula, the final result will also change to accommodate the new data.

To avoid adjusting the formula as you add new data, you can also include empty cells. For example, if you only have data in cells A1-A5and you want to sum the column as is. But you know you’ll be adding more data in the future, so you can set up your formula immediately like this:

=SUM (A1:A20)

This way you won’t have to change the formula when you add new data later – the new values ​​will be automatically added to the result.

If you’re not sure how many new cells to fill with data, you can sum the entire column and not worry about adding new values. Each time you do this, it will be added to the total value without needing to adjust the formula.

This is the formula to use:

=SUM (A:A)

Of course, you will write the appropriate letter, depending on the column you want to add.

How to Sum a Column in Google Sheets on a Windows PC, Mac, or Chromebook

If you need to use Google Sheets on different devices, you’re in luck. The application is compatible with all types of PCs, mobile phones and tablets.

You can use different browsers to access Google Sheets, but the steps are the same no matter what type of computer you are using.

1. Open the browser you normally use on your PC, Mac, or Chromebook.
   
2. Open Google Sheets and open the desired file or click White to open a new one.
   
3. Click a cell where you want to type the formula.
   
4. Enter the formula and the desired column you want to sum. It can be one column (A1:A20) or more (A1:C10).
   
5. If you want to sum different columns, you can also click on the first cell you want to include and then drag the rectangle to the last one to select all the cells in between.
   
6. When entering the formula, you will see the result in the desired cell, as soon as you type the closing parenthesis and press Get into.
   

Another way to do this is to enter only the cell numbers you want to sum. To do this, you must type the data you want to add and then follow these steps:

1. Navigate to the taskbar at the top.
   
2. On the right you will see the sign ∑ (the Greek letter sigma). Click here and select the ADDITION formula in the dropdown menu.
   
3. Enter the range of cells you want to add and press Get into to add the column.
   

How to sum a column in Google Sheets on the iPhone app

Google Sheets also works on mobile devices, which is great when you’re away from your computer and need to finish a task quickly.

If you are an iOS user, here we explain how to add a column in the iPhone app:

1. Open Google Sheets on your iPhone.
2. Choose the desired spreadsheet or open a blank one.
3. Enter the data or highlight the cells you want to sum.
4. Navigate to the bottom, where you will see different options, such as sum, average, etc.
5. Hold SHmm and drag the operation to the cell where you want the result to appear.
6. Release to see the result.

How to sum a column in Google Sheets on an Android device

Android users can also rely on their smartphones and tablets to calculate something on the go. If you need to use the SUM formula outside of the office, or just don’t feel like turning on your computer to do some clicking, here’s what you should do:

1. Launch the Google Sheets app on your Android device.
   
2. Open a new spreadsheet or find and start the one you need to edit.
   
3. Enter the necessary data or select the cells that contain the values ​​you want to sum.
   
4. At the bottom of the screen, there are different calculations to choose from: Addition, Minimum, Maximumand more.
   
5. Tap on ADDITIONHold and drag the function to the desired cell.
   
6. When you release the function, you will be able to see the result.
   

Note that you can also enter the formula manually if, for some reason, you cannot drag it to the desired cell. This applies to both Android and iOS devices.

1. To do this, you need to tap the Enter text or formula field at the bottom and when your keyboard appears, simply type the formula.
2. Select the cells you want to include by tapping them and they will be added to the formula automatically.
3. When finished, tap the check mark and the result will be displayed in the desired cell.

Be a math genius with Google Sheets

Who knew math could be so simple?

With Google Sheets, you can effortlessly add large numbers in seconds, calculate averages, and do much more. Formulas allow you to add different data and even entire columns. That way, you can stay on top of your tasks because you won’t have to waste time doing all the work manually. And the best thing about these features is that the chances of you making a mistake are minimal.

Have you already tried the ADDITION Does it work in Google Sheets? Share your experience in the comments section below.