Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. 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 28,195 times.
Learn more...
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
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.
Click the file you want to edit.Advertisement
Click the cell where you want to place the result. This can be any blank cell on the sheet.
Click Σ. It's near the top-right corner of the sheet. This opens the function menu.
Click SUM. It's at the top of the menu.
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.
Press ↵ Enter or ⏎ Return. The total of all values in the column now appears in the cell.
Expert Q&A
Tips
About This Article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
