Knowledge Books

Home → Google → Google Sheets → Using the SumIF Function

13.14. Using the SumIF Function

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. The SUMIF function is a great way to add up data IF that data meets a specific condition. The first step is to open your desired sheet, click into the cell you want the Function in, then click Insert

Step 1 image

2. With your mouse, hover Function►

Step 2 image

3. With your mouse, hover All►

Step 3 image

4. Scroll down and click SUMIF

Step 4 image

5. We are finding the sum of expenses from Taxis only. First, enter the data to pull from (column A for us), then type the condition to look for ("Taxi" for us), then enter the range of cells that contain the data to be added (B2 to B9)

Step 5 image

6. Hit enter . We now see that the total expenses from Taxis was $18.

Step 6 image

7. That's it. You're done. If you want, you can see other ways to format this formula using different conditions. This is in Column E, Cells 17, 21, 

Step 7 image

Here's an interactive tutorial

https://www.iorad.com/player/1740085/Docs-Google---How-to-untitled-task-name


Downloads

Knowledge Tags
Sum  /  function  /  Google Sheets  /  formula  / 

← Using the CountIF Function Using the Sparkline Function to Track Student Progress →