ExcelFlux

SUMPRODUCT function

the sum of the products of corresponding array components.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Multiply corresponding values and sum the products, such as a quantity times a unit price.

A worked example from the workbook

RowAB
6Input readingOutput reading
712
824
936
Record 1
=SUMPRODUCT(A7:A9,B7:B9)

Expected result28

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=SUMPRODUCT(A7:A9,B7:B9)
Turkish Excel · tr-TR
=TOPLA.ÇARPIM(A7:A9;B7:B9)

Worked examples

Multiply corresponding values and sum the products, such as a quantity times a unit price.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Input reading Output reading
7 1 2
8 2 4
9 3 6
Case Formula Expected result
Record 1 =SUMPRODUCT(A7:A9,B7:B9) 28
Record 2 =SUMPRODUCT(A7:A8,B7:B8) 10
Record 3 =SUMPRODUCT(A8:A9,B8:B9) 26
Microsoft Excel reference