How to Total a Column on Google Sheets on Android

This wikiHow teaches you how to find the sum of an entire column in Google Sheets for Android.

Steps

  1. Image titled Total a Column on Google Sheets on Android Step 1
    1
    Open Google Sheets. It’s the green icon with a white table usually found in the app drawer.
  2. Image titled Total a Column on Google Sheets on Android Step 2
    2
    Tap the file you want to edit.
  3. Image titled Total a Column on Google Sheets on Android Step 3
    3
    Tap an empty cell beneath the column. This opens the “fx” bar at the bottom of the sheet. It also springs open your Android’s keyboard.
  4. Image titled Total a Column on Google Sheets on Android Step 4
    4
    Type =SUM. A pop-up menu will appear.
  5. Image titled Total a Column on Google Sheets on Android Step 5
    5
    Tap SUM. The “fx” bar should now contain =SUM().
  6. Image titled Total a Column on Google Sheets on Android Step 6
    6
    Tap () after “SUM.” Now you can select the range you want to total.
  7. Image titled Total a Column on Google Sheets on Android Step 7
    7
    Tap the first cell in the column. This highlights the cell and surrounds it by a red dotted line. A large red circle appears at the bottom-right corner of the cell.
  8. Image titled Total a Column on Google Sheets on Android Step 8
    8
    Drag the red circle to select all cells in the range. The cells are now selected.
  9. Image titled Total a Column on Google Sheets on Android Step 9
    9
    Tap
    Image titled Android7done.png
    .     It’s on the right edge of the “fx” box. The sum of the selected cells now appears in the cell that contains the formula.

You Might Also Like

Download an APK File from the Google Play Store
How to
Download an APK File from the Google Play Store
Know Chat ID on Telegram on Android
How to
Know Chat ID on Telegram on Android
Disable Voicemail on Android
How to
Disable Voicemail on Android
Import Contacts from Excel to an Android Phone
How to
Import Contacts from Excel to an Android Phone
Save Photos on Telegram on Android
How to
Save Photos on Telegram on Android
Hide Apps on Android
How to
Hide Apps on Android
Hide the Notification Bar on Android
How to
Hide the Notification Bar on Android
Use an Android IR Blaster
How to
Use an Android IR Blaster
Get in App Purchases for Free (Android)
How to
Get in App Purchases for Free (Android)
Use Your Phone As a Mic
How to
Use Your Phone As a Mic
Use Lucky Patcher on Android
How to
Use Lucky Patcher on Android
View Who Is Connected to Your Hotspot on Android
How to
View Who Is Connected to Your Hotspot on Android

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 5,031 times.
How helpful is this?
Co-authors: 6
Updated: May 25, 2021
Views: 5,031
Categories: Android Applications