The basics

Multiply two columns and add the results

How it works in Excel

• Each number in A is multiplied by the one beside it in B.
• All of those results are then added up.
• Both ranges must be the same size.
• This saves you from adding a helper column.

The idea in general

It is how a shopping receipt works: quantity times price on each line, then one total.

What I assumed

• The quantities are in A2:A3 and the prices are in B2:B3.

Check the result on your own data before relying on it.