In this article, we will explain how to use Google Sheets SUMIF Function.
*You don’t need to add quotation marks when you enter the formula name
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.
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?
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 👇