How to Sum a Column in Google Sheets Mobile

Posted September 30, 2015 by Ashley Blood in Android, Apple iPhone, Google Sheets

Google Sheets

Google Sheets, a free alternative to Microsoft Excel, has a mobile and web version. Sheets does not have the full range of capabilities of Excel, but it works well with the touch interface of a mobile phone. I would not use Sheets to manage large datasets or do any serious computation, but it has the functionality that I am likely to use on the go. Google Sheets can be used offline, or it can sync with your Google Drive so that you can pull up all your Sheets on any computer or device. If you do not already have the Google Sheets app, you can download it by following these links for android or iOS.

One of the most common uses of spreadsheets is adding up lists of numbers. This is done by using the “Sum” formula. It is quick and easy and can be copied over multiple columns.

1.Enter your data. Tap the cell where you want to sum up your data, and then tap the formula bar on the bottom of the screen.Google Sheets sum



2.Next, type the following:


Then, select the range you want to sum. The easiest way to do this is to tap a cell in the range, and then drag a corner to highlight the whole target range in red. Type in a ). The total formula should look like this:


Note that the cells you are summing do not have to be in the same column. You can tap to select each cell manually that you want to add together. If you use this method, Sheets will separate each cell reference with a comma instead of using a colon to show a consecutive range. This would look something like this:

=sum(A2, A3, B2, B3, C2, C7)

Click the check mark to exit out of entry mode. The cell will now display the sum of the cells you selected.Google Sheets SUM

3.Perhaps you have multiple columns that you want to sum. This is easy to do with Autofill. Select the cell with the formula you just entered and the cells that you want to fill with the sum. Tap on the blue selected region, and tap the arrow to the right until you see Autofill. Select this option, and the cells will now contain a sum. Note that this used relative cell locations. This means that if the first cell contained a formula to sum rows 2 to 7 in column A, and you autofill this formula to columns B and C, the autofilled cells will contain the sum of rows 2 to 7 in columns B and C.  Google Sheets autofill


About Ashley Blood

Ashley is a mom, engineer, writer, and lover of gadgets and doing things efficiently.
View more articles by Ashley Blood

The Conversation

Follow the reactions below and share your own thoughts.