Using the SUM Function in Google Sheets

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
  3. Next to Explore, you'll see Sum: total
  4. To see more calculations, click Sum, Average, Minimum, Maximum, Count, or Count Numbers
Print Article