Sum Points for Specific Subject
I need to sum the total points a student earned only for 'Math' assignments.
=SUMIFS(D2:D8, A2:A8, "Alice", B2:B8, "Math") How it works: The SUMIFS function allows you to sum values based on multiple conditions. Here, it sums the 'Points Earned' (D2:D8) only for rows where the 'Student Name' (A2:A8) is 'Alice' AND the 'Subject' (B2:B8) is 'Math'. This precisely filters the data to give the total points for Alice's Math assignments.
Data Setup
| Student Name | Subject | Assignment | Points Earned |
|---|---|---|---|
| Alice | Math | Quiz 1 | 15 |
| Bob | Science | Lab Report | 20 |
| Alice | Math | Homework 1 | 10 |
| Charlie | History | Essay | 25 |
| Alice | Science | Quiz 1 | 12 |
| Bob | Math | Quiz 1 | 18 |
| Alice | Math | Exam | 30 |
Step-by-Step Guide
Identify the range containing the values you want to sum. In this case, it's the 'Points Earned' column (D2:D8).
Identify the first criteria range, which is the 'Student Name' column (A2:A8).
Specify the first criteria, which is the student's name, "Alice". Remember to enclose text in double quotes.
Identify the second criteria range, which is the 'Subject' column (B2:B8).
Specify the second criteria, which is the subject name, "Math". Again, enclose text in double quotes.
Combine these elements into the SUMIFS function: =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2).