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

Download Article

Explore this Article

Steps

Steps

Other Sections

Related Articles

Written by Nicole Levine, MFA

Last Updated: November 24, 2021

Download Article

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

Download Article

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. 
   2
   Click the file you want to edit.
   Advertisement
3. 
   3
   Click the cell where you want to place the result. This can be any blank cell on the sheet.
4. 
   4
   Click Σ. It's near the top-right corner of the sheet. This opens the function menu.
5. 
   5
   Click SUM. It's at the top of the menu.
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. 
   7
   Press ↵ Enter or ⏎ Return. The total of all values in the column now appears in the cell.
Advertisement

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Tips

Submit a Tip

All tip submissions are carefully reviewed before being published

Name

Please provide your name and last initial

Submit

Thanks for submitting a tip for review!