This guide was created with Scribe in 9 seconds. Sign in and create your own!
How to use SUMIF in Google Sheets
Created by Tiffany from Scribe | 5 steps
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)
Select the cell where you want to write your formula
Zoom Saved
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)
Your sumif total is displayed
Zoom Saved
Tiffany made this Scribe in 9 seconds.
Have something to say?Create an account to leave messages for the author to see!
Message sent!
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe