Arrow left
Back to product guides
Google Sheets Formulas

How to Use SUMIF Function in Google Sheets

In this article, we will explain how to use Google Sheets SUMIF Function.

How do I sum by condition in Google Sheets?

  1. Type “=SUMIF”* or go to the “Insert” → “Function” → “Math” → “SUMIF”.
  2. The “SUMIF” function requests three inputs from you**; range, criterion, and sum range.
  3. You can directly type in these elements between the brackets or input them by selecting specific ranges or cells with a cursor or a keyboard.
  4. Press the Enter key on your keyboard

*You don’t need to add quotation marks when you enter the formula name


=SUMIF(range, criterion, [sum_range])

Range: This is the column the function refers to check if there is data that matches the criterion.

Criterion: This could be a specific word/text, number, or date. You can input it directly in the formula or refer to a cell containing it.

Sum range: This range should correspond to the “Range” regarding the number of cells and directions.

How to add up numbers with a condition in Google Sheets

Let’s see examples below. Look at a formula shown in E11, which is next to 100 in the picture. This formula is to gather the total score of Division 1. In this formula, the range is $B$3:$B$8, the criterion is $C11, and the sum range is $D$3:$D$8.

How to add up numbers with a condition in Google Sheets

How do I sum cells with specific text in Google Sheets?

You can sum cells tied to specific text by following the approach explained above.

In the examples below, Division names are replaced with text (A or B), and Group names are changed to text (X, Y, or Z) as well. Can you see that the formulas still work the same way as in the examples above?

How to add up numbers with a condition in Google Sheets

Can you do Sumifs with three criteria?

Yes, you can, but you need to use the “SUMIFS” function for multiple criteria instead of the “SUMIF” function we introduce on this page.

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711