How to Total a Column on Google Sheets on PC or Mac

If you need to find the total of a column when you're using Google Sheets, look no further than the SUM function. You can create a simple formula with SUM that quickly adds all cells in any column. SUM also works to add values in rows, as well as in ranges that combine both rows and columns. We'll show you how easy it is use SUM to add numbers anywhere in your spreadsheet on your PC or Mac computer.

Steps

  1. Image titled Total a Column on Google Sheets on PC or Mac Step 1
    1
    Go to https://sheets.google.com in a web browser. If you're not already signed in to your Google account, follow the on-screen instructions to sign in now.
  2. Image titled Total a Column on Google Sheets on PC or Mac Step 2
    2
    Click the file you want to edit.
    Advertisement
  3. Image titled Total a Column on Google Sheets on PC or Mac Step 3
    3
    Click the cell where you want to place the result. This can be any blank cell on the sheet.
  4. Image titled Total a Column on Google Sheets on PC or Mac Step 4
    4
    Click Σ. It's near the top-right corner of the sheet. This opens the function menu.
  5. Image titled Total a Column on Google Sheets on PC or Mac Step 5
    5
    Click SUM. It's at the top of the menu.
  6. Image titled Total a Column on Google Sheets on PC or Mac Step 6
    6
    Select the cells you want to add. To do this, click the first cell in the column, then drag the cursor down until all cells are selected.
  7. Image titled Total a Column on Google Sheets on PC or Mac Step 7
    7
    Press ↵ Enter or ⏎ Return. The total of all values in the column now appears in the cell.
    8. Advertisement

You Might Also Like

Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Restore Google AuthenticatorHow to Restore Google Authenticator if You Lost or Reset Your Phone
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Google Sheets How to Insert Time in Cell Automatically4 Easy Ways to Add the Time and Date Automatically in Sheets
Write a Review on Google2 Ways to Write a Review on Google
Turn Off Google Ads
How to
Turn Off Google Ads
Make a Time Slot Sign Up Sheet on Google FormsHow to Make a Sign Up Sheet with Time Slots in Google Forms
Get a Google Voice Phone NumberHow to Sign Up for a New Google Voice Phone Number
Search by Image on GoogleReverse Image Search in Google Lens: Android, iPhone, & Desktop
Do Google GravityHow to Do the Google Gravity Trick in Your Browser
Make a Google Account5 Easy Steps to Create a Google Account on Any Device
Create a Website Using Google Sites
How to
Create a Website Using Google Sites
Delete a YouTube Account
How to
Delete a YouTube Account
Advertisement

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, 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 21,772 times.
How helpful is this?
Co-authors: 3
Updated: November 24, 2021
Views: 21,772
Categories: Google Applications | Spreadsheets
Article SummaryX

1. Go to https://sheets.google.com.
2. Click the file.
3. Click a blank cell.
4. Click Σ.
5. Click SUM.
6. Select all cells in the column.
7. Press ↵ Enter or ⏎ Return.

Did this summary help you?
Advertisement