SUMPRODUCT function in Excel

Use

The SUMPRODUCT function first multiplies corresponding arrays, then returns with the sum.

Syntax

=SUMPRODUCT (array1, [array2], …)

where,

array1 and [array2] are arrays whose values you want to first multiply then add.

Example

For example, the SUMPRODUCT function mentioned below calculates the total cost of the transaction.

The SUMPRODUCT function calculates the sum as under:

(2 * $10) + (2 * $5) + (2 * $19) = $68

If any text entry found within selected directions, then Excel will treat it as zero and returns with calculation of remaining values.

Common Error

The arrays must have same directions otherwise Excel will return he #VALUE! error.

One direction is missed in the formula:

Result:

Use of the SUMPRODUCT function

 

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved