5 steps | 9 seconds | Created by Tiffany from Scribe

docs.google.com

This Scribe shows you how to use the SUMIF function in Google Sheets. It will sum certain values based on a criteria you define. The syntax for SUMIF is as follows:
= sumif(Range, Criteria, Sum_Range)

1

Select the cell where you want to write your formula

Zoom Saved

2

Type "=sumif(A2:A8,A3,C2:C8)" and press ENTER

Tip! The criteria can be a cell or a hardcoded value or text string. If you wanted to use a text string for this example, the formula would look like:
= sumif(A2:A8,"Jessie",C2:C8)

3

Your sumif total is displayed

Zoom Saved