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 Print Article

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.