Basic FunctionsAdvanced

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.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of SUMPRODUCT

0/3

The same formula in the other shapes it takes at work.

  1. SUMPRODUCT Function

    Calculate weighted sums using SUMPRODUCT.

    CoreAdvanced
  2. SUMPRODUCT for an order total

    Quantity times price for every line, added up, in one cell.

    Intermediate
  3. A weighted average with SUMPRODUCT

    Each value counts in proportion to its weight.

    Advanced

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.

6 rows × 4 columns1 cell you fill in
ABCD
1SubjectScoreWeightWeighted Score (for info)
2Math850.3
3Science920.4
4English780.3
5
6Total Weighted Score

Functions used here

What this exercise teachesMay contain 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.