How to sum a column in Google Sheets mobile on iPhone: smart tips

If you want to know how to sum a column in Google Sheets mobile on iPhone, the answer is a few taps and one short formula. Android works almost the same way. The harder part is trusting the total, because a small screen hides the things that throw a sum off. Below you will find the quick total, the SUM formula, and the checks that catch bad numbers.

Get a quick total without typing a formula

Google's Help Center explains the fastest route: open the spreadsheet in the Google Sheets app, highlight the cells you want to calculate, and look at the bottom of the screen. The sum and average show up there. Nothing gets written into your sheet, so you cannot break anything with a quick check.

The catch is that the number vanishes when you tap away. You cannot copy it or point another formula at it. It also covers only the cells you highlighted, so a missed row at the bottom gives you a short answer without any warning.

How to sum a column in Google Sheets mobile on iPhone with a formula

A formula keeps the total in the sheet and updates it when the numbers change. Tap an empty cell, type the formula, and confirm it with the checkmark or the return key. This is the one most people need:

=SUM(B2:B20)

B2:B20 means every cell from B2 down to B20. Swap in your own column letter and row numbers. Keep the total outside that range, otherwise the cell tries to add itself and Sheets flags a circular dependency. Typing addresses on a small keyboard invites typos, so tap and drag across the cells where your app allows it.

Here are the range styles worth knowing:

• =SUM(B2:B20) adds a fixed block of rows.
• =SUM(B2:B) adds from B2 to the bottom, so new rows count automatically.
• =SUM(B:B) adds the whole column and ignores a text header.
• =SUM(B2:B20, D2:D20) adds two separate columns into one total.

The open-ended B2:B style suits lists that keep growing, like weekly expenses. Just remember it only works when the formula lives in a different column. Android users follow the same steps, though menu icons may sit in slightly different places.

Once the formula is in, highlight the same cells and compare the bottom total with your formula result. A match confirms the range covers what you meant. A mismatch usually means the range stops a row early or includes a stray cell, so adjust the end of the range and compare again.

A total you cannot explain is a total you should not send.

Why your total looks wrong and how to check it

Knowing how to sum a column in Google Sheets mobile on iPhone only helps if the cells are clean. Most wrong totals trace back to the data, not the formula. Three causes cover nearly every case, and you can test all three from your phone.

Numbers stored as text

SUM skips text. A value like 1,200 that arrived as text from an import adds zero to your total. Text usually hugs the left edge of a cell, while real numbers sit on the right. A quick test is to compare two counts: =COUNT(B2:B20) counts only real numbers, while =COUNTA(B2:B20) counts every filled cell. If the two results differ, some of your numbers are text.

If the total shows 0 even though the column is full of figures, text is the likely cause. Set the column to a number format, then retype one value to test it. When the cells still refuse to change, this formula converts them on the fly:

=ARRAYFORMULA(SUM(B2:B20*1))

It returns #VALUE! if a cell holds real words, which tells you where to look. Our guide to fixing Google Sheets errors covers that message in more detail.

Hidden and filtered rows

SUM adds every cell in the range, including rows a filter hides. If you filtered a list to one client and want only the visible total, switch to SUBTOTAL:

=SUBTOTAL(109,B2:B20)

The 109 tells Sheets to ignore hidden rows. The plain 9 version skips filtered rows but still counts rows you hid by hand, so pick 109 when in doubt.

Ranges that stop short

A fixed range like B2:B20 never includes row 21. If you add data below it, the total quietly stays the same. The open-ended B2:B style fixes this, and so does a table.

According to Ben Collins' guide to Tables in Google Sheets, formulas that use table references update to include any new rows. A table name can only contain letters and numbers. His example references look like Properties[Value], so a total becomes:

=SUM(Properties[Value])

Collins also notes that tables work best with uniform data, so blank rows and subtotals inside your list can confuse them. If you cannot find the table option in the app, build the table on a computer first. Then check the total from your phone.

Other columns, other tools

Once you know how to sum a column in Google Sheets mobile on iPhone, extending the idea is simple. Need a total across several columns? =SUM(B2:D20) adds the whole block, while commas let you pick separate columns. For repeating patterns, Exceljet's example of summing every nth column in Excel uses FILTER, MOD and SEQUENCE to total every third column. It returns 17 for its sample data. That is overkill on a phone, but it shows how a formula scales when picking cells by hand gets tedious.

To total only some rows, use SUMIF. For example, this adds the amounts in column B where column A says Client A:

=SUMIF(A2:A20,"Client A",B2:B20)

The first range holds the labels, the text in quotes is the match, and the last range holds the numbers to add. Keep the ranges the same size so the rows line up.

If your column holds labels rather than numbers, a sum is the wrong tool. Contextures explains how to show text values in a pivot table, which suits that job better. And if you plan to print a sheet with the total showing, TechRepublic has a step-by-step guide to setting the print area in Google Sheets.

You can also skip the syntax. Describe the result to the Formula Foundry formula generator, paste what it returns into your sheet, and then run the COUNT check above. For more habits that cut mistakes, read our post on formulas in Google Sheets.

Whenever you sum a column in Google Sheets mobile on iPhone or Android, run COUNT against COUNTA before you touch the formula. It takes ten seconds, and it catches the most common culprit.

Action steps

1. Try the quick total: Open the sheet in the Google Sheets app, highlight the column cells, and read the sum at the bottom of the screen.
2. Write the SUM formula: Tap an empty cell outside the range and enter =SUM(B2:B20), using your own column letter and row numbers.
3. Use an open-ended range: Switch to =SUM(B2:B) if the list keeps growing so new rows count automatically.
4. Compare COUNT and COUNTA: Enter =COUNT(B2:B20) and =COUNTA(B2:B20). If the results differ, some numbers are stored as text.
5. Switch to SUBTOTAL for filtered lists: Use =SUBTOTAL(109,B2:B20) when you want only the visible rows in the total.

Frequently asked questions

Can I see a sum in Google Sheets mobile without a formula?

Yes. Open the spreadsheet in the Google Sheets app, highlight the cells you want to calculate, and check the bottom of the screen for the sum and average. The figure is not saved in the sheet.

Why does my SUM show 0 on my phone?

The cells probably hold numbers stored as text, and SUM skips text. Compare COUNT with COUNTA on the same range. If they differ, set the column to a number format or use =ARRAYFORMULA(SUM(B2:B20*1)).

Does SUM include hidden or filtered rows?

SUM adds every cell in its range, including hidden and filtered rows. Use =SUBTOTAL(109,B2:B20) to total only the visible rows.

How do I sum a column that keeps growing?

Use an open-ended range such as =SUM(B2:B), and keep the formula in a different column. A table with structured references also picks up new rows, but set it up on a computer if the app does not offer the option.

Is the process different on Android?

The formulas are the same on Android and iPhone. Menu icons can sit in slightly different places, so look for the same options in your version of the app.