Excel Function

SUMPRODUCT

Returns sum of products of arrays.

SUMPRODUCT(array1, [array2], ...)

Arguments

array1

Required

Specify a reference range. You can drag or click start/end cells.

array2

Optional

Specify a reference range. You can drag or click start/end cells.

Practice Preview

display numeric calculation results. Use SUMPRODUCT to Returns sum of products of arrays. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=SUMPRODUCT(C2:C8, D2:D8)

Practice This Function

Practice in Sequential Mode Back to Function List