How to use SUMIF in Google Sheets | Scribe
    logged out logo

    How to use SUMIF in Google Sheets

    • Google SheetsGoogle Sheets
    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)
    Your sumif total is displayed
    Documents you might like
    0 Selected
    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe