The SUMIF function is to calculate the sum of a series of numbers that meet one criterion such as gender, grade, and group. If you need to get the sum of the scores in a school by each grade, you can use the SUMIF function.
Example: You worked on the data with the student's scores, and one of the requests is to get the total scores for each grade.
In the dataset, the grade is in column B and the students' scores are in column C.
Formula 1: To get the total scores for grade 1
=SUMIF(B2:B16, 1, C2:C16)
Formula 2: To get the total scores for grade 2
=SUMIF(B2:B16, 2, C2:C16)
Formula 3: To get the total scores for grade 3
=SUMIF(B2:B16, 3, C2:C16)
Formula 4: To get the total scores for grade 4
=SUMIF(B2:B16, 4, C2:C16)
Formula 5: To get the total scores for grade 5
=SUMIF(B2:B16, 5, C2:C16)
Notes: The SUMIF function
The SUMIF function adds all the numbers with the criteria you specified.
Formula:
=SUMIF(range, criteria, [sum_range])
Explanations:
– The range is required, which is the criteria range.
– The criterion is required, the criteria for the sum.
– Sum_range is optional, the cells to add together.