Using the SUM function in Google Sheets

Question

How to use the SUM function in Google Sheets?

Answer

With a formula:

  1. Open a spreadsheet.
  2. Type an equal sign (=) in a cell and type in the function you want to use. We will type in SUM
  3. A function help box will be visible throughout the editing process to provide you with a definition of the function and its syntax, as well as an example for reference. If you need more information, click the Learn more link at the bottom of the help box to open a full article.

With the Explore button:

  1. Highlight the cells you want to calculate
  2. In the bottom right, find Explore Explore
  3. Next to Explore, you'll see Sum: total
  4. To see more calculations, click Sum, Average, Minimum, Maximum, Count, or Count Numbers

For more information about Sheets, please view the full tutorial from the CTL here: Google Sheets

If you need further assistance, please click the CTL Support Request button on this page

CTL Support Request

Details

Article ID: 7843
Created
Tue 12/20/22 12:01 PM
Modified
Fri 11/3/23 4:23 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.