How To Total A Column On Google Sheets On PC Or Mac - WikiHow

Home » How To Total A Column In Google Sheets » How To Total A Column On Google Sheets On PC Or Mac - WikiHow

Maybe your like

Skip to ContentQuizzes
  • Home
  • Random
  • Browse Articles
  • Quizzes & Games
  • All QuizzesHot
  • Love Quizzes
  • Personality Quizzes
  • Fun Games
  • Dating Simulator
  • Learn Something New
  • Forums
  • Courses
  • Happiness Hub
  • Explore More
  • Support wikiHow
  • About wikiHow
  • Log in / Sign up
Terms of Use wikiHow is where trusted research and expert knowledge come together. Learn why people trust wikiHow How to Total a Column on Google Sheets on PC or Mac PDF download Download Article Explore this Article Steps Steps Other Sections Related Articles Written by Nicole Levine, MFA

Last Updated: November 24, 2021

PDF download Download Article X

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 31,405 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

PDF download Download Article
  1. Step 1 Go to https://sheets.google.com... 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. Step 2 Click the file you want to edit. 2 Click the file you want to edit. Advertisement
  3. Step 3 Click the cell where you want to place the result. 3 Click the cell where you want to place the result. This can be any blank cell on the sheet.
  4. Step 4 Click Σ. 4 Click Σ. It's near the top-right corner of the sheet. This opens the function menu.
  5. Step 5 Click SUM. 5 Click SUM. It's at the top of the menu.
  6. Step 6 Select the cells you want to add. 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. Step 7 Press ↵ Enter or ⏎ Return. 7 Press ↵ Enter or ⏎ Return. The total of all values in the column now appears in the cell.
    8. 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!

You Might Also Like

Add Up Columns in ExcelHow to Add Up Columns in Microsoft Excel: Quickly Sum Numbers Use the Sum Function in Microsoft ExcelHow toUse the Sum Function in Microsoft Excel Sum Multiple Rows and Columns in ExcelHow toSum Multiple Rows and Columns in Excel Add in ExcelHow to Add Numbers & Cells in Excel: Complete Guide Add Two Cells Containing the Sum of Other Formulas in ExcelHow to Add Two Cells Containing the Sum of Other Formulas in Excel Use Summation Formulas in Microsoft ExcelHow to Use the SUM Function in Excel to Add Cells, Ranges, & Numbers Apply a Formula to an Entire Column on Google Sheets on PC or MacHow toApply a Formula to an Entire Column on Google Sheets on PC or Mac Use Google SpreadsheetsHow to Use Google Sheets: The Ultimate Guide for Getting Started Create a Budget SpreadsheetHow toCreate a Budget Spreadsheet Make a Google SpreadsheetHow to Make a Google Spreadsheet: Beginners Guide Subtract in ExcelHow toSubtract in Excel Sort by Multiple Columns in Google SpreadsheetsHow toSort by Multiple Columns in Google Spreadsheets Sort by Number on Google Sheets on PC or MacThe 3 Easiest Ways to Sort by Number in Google Sheets Highlight a Whole Column in Google Sheets3 Simple Ways to Highlight a Column in Google Sheets 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 31,405 times. How helpful is this? Co-authors: 3 Updated: November 24, 2021 Views: 31,405 Categories: Google Applications | Spreadsheets
  • Print
  • Send fan mail to authors
Thanks to all authors for creating a page that has been read 31,405 times.

Is this article up to date?

Yes No Advertisement Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy. Nicole Levine, MFA Written by: Nicole Levine, MFA wikiHow Technology Writer Click a star to vote Co-authors: 3 Updated: November 24, 2021 Views: 31,405

Quizzes & Games

IQ TestIQ TestTake QuizPizza CalculatorPizza CalculatorLife Path Number CalculatorLife Path Number CalculatorIQ Test For KidsIQ Test For KidsTake QuizWhat Is My Numerology Number QuizWhat Is My Numerology Number QuizTake QuizRandom Name GeneratorRandom Name GeneratorGenerate Names

You Might Also Like

Add Up Columns in ExcelHow to Add Up Columns in Microsoft Excel: Quickly Sum NumbersUse the Sum Function in Microsoft ExcelHow toUse the Sum Function in Microsoft ExcelSum Multiple Rows and Columns in ExcelHow toSum Multiple Rows and Columns in ExcelAdd in ExcelHow to Add Numbers & Cells in Excel: Complete Guide

Trending Articles

Look Your BestHow toLook Your BestWhat Emojis Mean Sex?What Emojis Mean Sex?The Different Kinds of Dimples: Types, Causes, & Social PerceptionThe Different Kinds of Dimples: Types, Causes, & Social Perception151 of the Juiciest “Most Likely To” Questions to Ask151 of the Juiciest “Most Likely To” Questions to AskSigns a Woman is Sexually Attracted to YouSigns a Woman is Sexually Attracted to YouDo You Agree with These Hygiene Hot Takes?Do You Agree with These Hygiene Hot Takes?

Watch Articles

Calculate the Volume of a PyramidHow toCalculate the Volume of a PyramidThe Best Way to Exfoliate Your Scalp (Plus, What to Use)The Best Way to Exfoliate Your Scalp (Plus, What to Use)Save Money as a KidHow toSave Money as a KidPolish AluminumHow toPolish Aluminum2 Easy Renter-Friendly Options to Hang Your Window Treatments2 Easy Renter-Friendly Options to Hang Your Window Treatments Insert Slide Numbers in PowerPointHow to Insert Slide Numbers in PowerPoint

Trending Articles

Why Can't I Sleep QuizWhy Can't I Sleep QuizBe PrettyHow toBe PrettyThe Most Attractive Zodiac Signs & What Makes Each Sign BeautifulThe Most Attractive Zodiac Signs & What Makes Each Sign Beautiful24 Different Types of Bras Explained24 Different Types of Bras Explained Play the Concentrate Game (For A Little Scare!)How to Play the Concentrate Game (For A Little Scare!)What Does Your Rice Purity Score Really Mean?What Does Your Rice Purity Score Really Mean?

Quizzes & Games

Last Name Generator​Last Name Generator​Generate NamesMemory TestMemory TestTake QuizSong Name GeneratorSong Name GeneratorGenerate NamesAdvanced Roulette GameAdvanced Roulette GamePlayAm I Smarter than a 5th Grader QuizAm I Smarter than a 5th Grader QuizTake QuizAm I Smart QuizAm I Smart QuizTake Quiz wikiHow
  • Categories
  • Computers and Electronics
  • Software
  • Office
  • Spreadsheets
wikiHow Newsletter You're all set! Helpful how-tos delivered toyour inbox every week! Sign me up! By signing up you are agreeing to receive emails according to our privacy policy.
  • Home
  • About wikiHow
  • Experts
  • Jobs
  • Contact Us
  • Site Map
  • Terms of Use
  • Privacy Policy
  • Do Not Sell or Share My Info
  • Not Selling Info
  • Contribute

Follow Us

×

Keep up with tech in just 5 minutes a week!

Subscribe You're all set! X --399

Tag » How To Total A Column In Google Sheets