Knowledge Books

Home → Google → Google Sheets → Using the Sum Function to Add Multiple Cells

13.7. Using the Sum Function to Add Multiple Cells

Directions: There are four options to view the resources below: try it, view it, watch it, or print it. Click the drop down menu titled "Try-It Interactive" to select your preferred viewing method. Then, click start.


7 STEPS

1. Open your google sheet and select the cell in which you would like to use the "Sum" Function. In this case, Cell Q:12

Step 1 image

2. Click Insert

Step 2 image

3. With your mouse, click Function

Step 3 image

4. Scroll to the top to find the SUM function

Step 4 image

5. The sum function is now ready in my cell, but I need to tell it what to add up. To do so, highlight the range of cells you want to be added.

Step 5 image

6. We are adding Cells Q1 through Q11, which is formatted in the function as "(Q2:Q11)".

Step 6 image

7. Click out of the cell Q12 and we can now see the result of our sum function, which is 67. That's it. You're done.

Step 7 image

Here's an interactive tutorial

https://www.iorad.com/player/1737583/Google-Sheets---Using-the--Sum--Function


Downloads

Knowledge Tags
Sum  /  addition  /  cells  /  Google Sheets  /  functions  /  function  / 

← Creating Filters for Data Collected in a Google Sheet Using the Average Function →