Basic Functions
Advanced
SUMPRODUCT Function
Calculate weighted sums using SUMPRODUCT.
Task:
You are calculating a student's total weighted score based on different subject scores and their respective weights. Calculate the total weighted score in cell D6 using SUMPRODUCT to properly weigh each subject's contribution to the final grade.
Learning Objectives:
- Master SUMPRODUCT function
- Understand weighted calculations
- Practice array operations
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Subject | Score | Weight | Weighted Score (for info) |
| 2 | Math | 85 | 0.3 | |
| 3 | Science | 92 | 0.4 | |
| 4 | English | 78 | 0.3 | |
| 5 | ||||
| 6 | Total Weighted Score |
What this exercise teaches (contains the answer)
SUMPRODUCT is powerful for weighted calculations. It multiplies items in arrays together and then sums the results, useful for calculating weighted averages or total revenues when prices and quantities are in separate arrays.