Skip to content
Lesson 4/4

SUMPRODUCT: multiply, then add

Exercise 1 of 1

Each row has a quantity and a price. In C7, work out the order total in one formula.

About this lesson

SUMPRODUCT multiplies ranges row by row and adds the results, so a total like quantity × price fits in a single cell.

In this lesson

  1. Each row has a quantity and a price. In C7, work out the order total in one formula.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in C7 and press Enter to check.