Excel practice · Putting It Together

SUMPRODUCT practice exercises

5 graded problems with realistic data, all hard.

Multiplies two (or more) ranges element by element, then sums the results, all in one formula. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.

New to the function? Read the SUMPRODUCT guide first: syntax, a worked example and the mistakes people make.

In this set

  1. Total cost from quantity × price
  2. Total portfolio value
  3. Total labor cost from hours × rate
  4. Total profit from units × margin
  5. Total weighted budget allocation

The exercises

1. Total cost from quantity × price Hard

Each item has a quantity and a unit price. Find the total cost across all items in one formula, with no helper column.

ABCDE
1ItemQtyPriceTotal Cost:?
2Pens101.2
3Pads43.5
4Clips200.5

Enter a formula in E1.

Show a hint

SUMPRODUCT(range1, range2) multiplies each pair of cells and sums the results: =SUMPRODUCT(B2:B4,C2:C4).

Without SUMPRODUCT, this needs a helper column (Qty×Price per row) before you can SUM it. SUMPRODUCT skips the helper column entirely.

2. Total portfolio value Hard

A small portfolio lists shares held and price per share for each of four holdings. Find the total portfolio value.

ABCDE
1HoldingSharesPricePortfolio Value:?
2Stock A5012
3Stock B308
4Stock C2025
5Stock D1510

Enter a formula in E1.

Show a hint

One more holding than the last example, same idea: =SUMPRODUCT(B2:B5,C2:C5).

Shares × price, summed across holdings, is literally how a portfolio's value is calculated. This is a real finance formula, not a toy example.

3. Total labor cost from hours × rate Hard

Three workers each belong to a department and logged different hours at different hourly rates. Find the total labor cost.

ABCDEF
1WorkerDeptHoursRateTotal Labor Cost:?
2W1Sales815
3W2Sales618
4W3Ops1012

Enter a formula in F1.

Show a hint

The Dept column is just along for the ride; multiply Hours by Rate: =SUMPRODUCT(C2:C4,D2:D4).

Payroll and staffing-cost models are built on exactly this hours × rate, summed pattern.

4. Total profit from units × margin Hard

Each product sold a number of units at a per-unit margin (row 2 just notes the quarter). Find the total profit across all products.

ABCDE
1QuarterQ3Total Profit:?
2ProductUnitsMargin
3P11002.5
4P2604
5P3403

Enter a formula in E1.

Show a hint

=SUMPRODUCT(B3:B5,C3:C5).

Profit contribution by product, summed, is a core piece of any margin analysis.

5. Total weighted budget allocation Hard

Each of four departments has a weight and a base budget (row 1 just notes the quarter). Find the total weighted budget across departments.

ABCDEF
1QuarterQ3Weighted Total:?
2DeptWeightBase Budget
3Sales0.410000
4Ops0.358000
5Marketing0.26000
6Support0.054000

Enter a formula in F1.

Show a hint

=SUMPRODUCT(C3:C6,D3:D6).

Weighted allocations like this show up constantly in budget modeling and in weighted-average calculations generally.

Solve these in a real grid

Type your formula, get graded instantly. Your first 10 exercises are free, no signup.

Start the SUMPRODUCT exercises →

More putting it together practice

All Excel practice exercises · Excel test prep