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

How do I sum by condition in Google Sheets?

Type “=SUMIF”* or go to the “Insert” → “Function” → “Math” → “SUMIF”.

The “SUMIF” function requests three inputs from you**; range, criterion, and sum range.

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.

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.

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 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?

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.