Excel + Google Sheets · SUMPRODUCT

Multiply and add in one step

Multiplies the ranges row by row and adds the results.

The formula

=SUMPRODUCT(B2:B4, C2:C4)

What each part means

B2:B4Quantities
C2:C4Prices

Example

Before

	A	B	C
1	Item	Qty	Price
2	Paper	3	10
3	Ink	2	25
4	Pens	5	4
5	Total

After

	A	B	C
1	Item	Qty	Price
2	Paper	3	10
3	Ink	2	25
4	Pens	5	4
5	Total		100

Step by step

Click cell C5.
Type the formula: =SUMPRODUCT(B2:B4, C2:C4)
Press Enter.

Where it works

Every version of Excel
Google Sheets
Excel for the web (free)

The same formula in other languages

English SUMPRODUCT
Español SUMAPRODUCTO
Português SOMARPRODUTO

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

Highlight the topMake the top value glow WORKDAYGet the deadline in working days &Join cells with one symbol COUNTA + UNIQUECount unique values TEXTAFTERCut any text after a character AI promptInitials from any name, written by AI