Sum Points for Specific Assignment Type
As a teacher, I want to calculate the total points earned across all students specifically on 'Homework' assignments, ignoring other assignment types like quizzes or exams. This helps me track overall progress for a particular category of work.
=SUMIF(A2:A8,"Homework",B2:B8) How it works: The `SUMIF` function works by evaluating a specified range (A2:A8 for 'Assignment Type') against a given criterion ("Homework"). For every cell in the range that matches the criterion, it adds the corresponding value from another specified range (B2:B8 for 'Points Earned') to the total. This allows you to sum points exclusively for 'Homework' assignments, effectively filtering out other assignment types like 'Quiz' or 'Exam'.
Data Setup
| Assignment Type | Points Earned |
|---|---|
| Homework | 10 |
| Quiz | 8 |
| Homework | 15 |
| Exam | 90 |
| Quiz | 7 |
| Homework | 12 |
| Homework | 20 |
Step-by-Step Guide
Open your Excel worksheet containing the assignment data.
Identify the column that contains the 'Assignment Type' (e.g., Column A) and the column with 'Points Earned' (e.g., Column B).
Select an empty cell where you want the total 'Homework' points to appear (e.g., C2).
Type the formula: `=SUMIF(`.
Select the range of cells in the 'Assignment Type' column that you want to evaluate (e.g., `A2:A8`). This is your 'range' argument.
Type a comma `,` followed by the criteria in double quotes: `"Homework"`. This tells Excel to look for 'Homework' in the specified range.
Type another comma `,` followed by the range of cells in the 'Points Earned' column that you want to sum (e.g., `B2:B8`). This is your 'sum_range' argument.
Close the parenthesis `)` and press Enter.
Explore More
Count Students Who Passed the Exam
I need to quickly count how many students scored above 60 in the final math exam.
Retrieve Student Guardian Contact Info
I have a student ID in one sheet and need to pull their guardian's email address from the school registry.
Combine First and Last Names for Roster
I have student first names in column A and last names in column B and need to merge them into 'Last, First' format.
Assign Letter Grades Based on Score
I want to automatically assign 'A', 'B', 'C', or 'F' based on the numeric score in the adjacent cell.