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

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)

docs.google.com

How to use SUMIF in Google Sheets

Scribe Co

Admin

Can add organization

Can change organization

Can delete organization

Can view organization

Can view scribe user

Has super admin permission

Can change super organization

Can view super organization

Can add role

Can change role

Can delete role

Can view role

Can add user organization permission

Can change user organization permission

Can delete user organization permission

Can view user organization permission

Scribe

enterprise

How to use SUMIF in Google Sheets

Tiffany made this Scribe in 9 seconds.

Favorite this Scribe?