How to Sum a Column in Google Sheets on Mobile & Desktop

Summing a column in Google Sheets is one of the most common tasks, whether you’re tracking expenses, managing a budget, or analyzing data. This guide covers the exact steps for both the mobile app (Android and iOS) and the desktop web version, so you can get the total quickly no matter where you’re working. You’ll learn the fastest methods, including the SUM function, the built-in shortcut, and how to handle filtered data.

What You’ll Need

• A Google account with access to Google Sheets (free).
• The Google Sheets mobile app installed on your phone or tablet (for the mobile section).
• A spreadsheet with a column of numbers you want to add.

Step-by-Step: Desktop (Web Browser)

1. Open your spreadsheet in a web browser (Chrome, Firefox, Safari, etc.) by going to sheets.google.com and clicking the file.
2. Select the cell where you want the sum to appear. This is usually at the bottom of the column, just below the last number, but it can be anywhere you choose.
3. Type the SUM formula directly into the cell: =SUM(. Alternatively, click the Functions icon (the Greek sigma Σ) in the toolbar and choose SUM.
4. Select the range of cells you want to add. You can either type the range manually (e.g., A2:A20) or click and drag to highlight the cells after typing =SUM(. The range will appear in the formula as you drag.
5. Close the parentheses and press Enter. The total will appear in the selected cell.
6. Use the shortcut (optional): Click an empty cell directly below the column of numbers, then press Alt + Shift + = (Windows) or Cmd + Shift + T (Mac). Google Sheets will automatically insert a SUM formula and guess the range.
7. Check the status bar (quick view): If you don’t need a permanent formula, just highlight the column of numbers with your mouse. The sum, average, and count will appear in the bottom-right status bar of the browser window.

Step-by-Step: Mobile App (Android & iOS)

1. Open the Google Sheets app on your phone or tablet and open the spreadsheet you want to edit.
2. Tap the cell where you want the sum to appear. This will bring up the keyboard and the editing toolbar.
3. Tap the function icon (the Greek sigma Σ) located at the top of the keyboard, next to the text formatting options. If you don’t see it, tap the fx symbol or the plus (+) icon to expand the toolbar.
4. Select SUM from the list of functions that appears. A formula like =SUM() will be inserted into the cell.
5. Select the range of cells you want to add. The app will automatically try to guess the range (usually the cells directly above). If it’s correct, tap the checkmark (✓) to accept. If not, tap and drag the blue selection handles to highlight the correct cells, then tap the checkmark.
6. Press the checkmark again to confirm the formula. The total will appear in the cell.
7. Alternative method: Type =SUM( directly into the cell, then drag your finger over the cells you want to include. Release and press the checkmark.

Common Mistakes

• Including the total cell in the range: If you put the formula in the same column as your data and accidentally include that cell in the range, you’ll get a circular reference error. Always make sure the formula cell is outside the selected range.
• Text in the column: If any cell in the range contains text (like a label or a dash), the SUM function will ignore it, but it might not give you the result you expect if you thought it was a number. Check for hidden text or spaces.
• Using the wrong range: Double-check that you selected the correct rows. It’s easy to miss a row at the top or bottom, especially on mobile where the screen is small.
• Forgetting to press Enter (desktop): If you type a formula but don’t press Enter, it won’t calculate. Clicking away from the cell without pressing Enter will revert the cell to its previous value.
• Using the status bar sum as a permanent value: The status bar sum disappears when you deselect the cells. If you need a permanent total, use a formula.

Tips

• Use keyboard shortcuts on desktop: Press Alt + Shift + = (Windows) or Cmd + Shift + T (Mac) to instantly insert a SUM formula below a column of numbers.
• Sum an entire column: Instead of typing a specific range, you can use =SUM(A:A) to add up all numbers in column A. This is useful if you keep adding data, but be careful not to include the formula cell itself (e.g., if the formula is in A1, this would cause a circular reference).
• Sum filtered data: If you have a filter applied to your sheet, the SUM function will still sum all visible and hidden cells. To sum only visible cells, use the SUBTOTAL function: =SUBTOTAL(109, A2:A20). The number 109 tells it to sum visible cells only.
• Add multiple columns at once: You can sum multiple columns in one formula: =SUM(A2:A20, C2:C20) adds both columns.
• Format the result: If your sum shows as a date or a long decimal, go to Format > Number and choose the appropriate format (e.g., Number, Currency, or Custom).

Troubleshooting

• The sum is 0 or wrong: Check if the cells are formatted as text. Select the cells, go to Format > Number > Number (or Automatic). If they were text, you may need to re-enter the numbers. Also look for leading apostrophes (‘) which force text format.
• Circular reference error: This means your formula includes its own cell. Click the error message to see which cell is causing it, then adjust the range to exclude that cell.
• Formula not calculating: Make sure you pressed Enter (desktop) or the checkmark (mobile). Also check that the cell is not formatted as text (Format > Number > Number).
• SUM function not showing in the mobile app: The function icon (Σ) might be hidden. Tap the fx symbol or the plus (+) icon to expand the toolbar. If that doesn’t work, type =SUM( manually.
• Status bar sum doesn’t appear on desktop: The status bar shows the sum only when you select multiple cells. If you only select one cell, it won’t show. Also, check that the cells contain numbers, not text.

Frequently Asked Questions

Can I sum a column without using a formula?

Yes. On desktop, highlight the column and look at the status bar at the bottom right—it shows the sum temporarily. On mobile, there is no such quick view, so you’ll need to use a formula.

How do I sum only visible cells after filtering?

Use the SUBTOTAL function with the function number 109: =SUBTOTAL(109, A2:A20). This sums only the cells that are not hidden by a filter.

Why is my sum showing as a date or time?

This happens when the cell format is set to Date or Time. Select the cell, go to Format > Number > Number (or Currency) to change it.

Can I sum a column on the mobile app without typing the formula?

Yes. Tap the cell where you want the sum, tap the function icon (Σ), choose SUM, and the app will usually guess the range. You can adjust it with the blue handles.

What does #REF! error mean when summing?

This error usually means the range is invalid, often because a row or column was deleted. Check the formula and update the range to the correct cells.

How do I sum an entire column except the header?

Use a range that starts at the first data row, like =SUM(A2:A) (if row 1 is the header). This sums everything from row 2 to the bottom of the column.

Related

• iPhone Hotspot Not Working? Here’s How to Fix It
• Do Not Disturb Setup Windows: How to Use It
• How to Check NFC Support on Android Phones