Sum Credits by Department
I need to sum the total 'Credit Hours' where the Department is 'Science' and Level is 'Undergraduate'.
=SUMIFS(D2:D7, B2:B7, "Science", C2:C7, "Undergraduate") How it works: The `SUMIFS` function allows you to sum values in a range that meet multiple criteria. In this scenario, it first looks at the 'Department' column (B2:B7) and identifies rows where the department is "Science". Simultaneously, it checks the 'Level' column (C2:C7) for rows where the level is "Undergraduate". Only rows that satisfy *both* conditions will have their corresponding 'Credit Hours' (from D2:D7) added to the total sum.
Data Setup
| Course ID | Department | Level | Credit Hours |
|---|---|---|---|
| C101 | Science | Undergraduate | 3 |
| C102 | Arts | Undergraduate | 4 |
| C103 | Science | Graduate | 3 |
| C104 | Science | Undergraduate | 4 |
| C105 | Arts | Graduate | 3 |
| C106 | Science | Undergraduate | 3 |
Step-by-Step Guide
Select the cell where you want the result to appear (e.g., A10).
Type `=SUMIFS(`. The first argument is the sum_range.
Select the range containing the values you want to sum (Credit Hours), which is `D2:D7`, then type a comma.
Select the first criteria range (Department), which is `B2:B7`, then type a comma.
Type the first criteria, `"Science"` (remember to enclose text in double quotes), then type a comma.
Select the second criteria range (Level), which is `C2:C7`, then type a comma.
Type the second criteria, `"Undergraduate"`, then close the parenthesis `)`.
Press Enter to get the total sum.