Microsoft Excel Functions & Formulas

Use the SUMPRODUCT function to calculate

the value of the inventory

In this example, the costs of all products in a warehouse have to be

summed up to obtain the value of the entire inventory. To do so,

use the SUMPRODUCT function. This function multiplies corre-

sponding components in the given arrays and returns the sum of

those products.

SUMPRODUCT(array1, array2, array3, ...)

array1, array2, array3, ...: From2 to 30 arrays whose compo-

nents to be multiplied and then added.

4

To calculate the inventory value:

1. Enter the data shown in columns A and B in Figure 6-8.

The quantity of each product is listed along with the cost of

each unit.

2. Select cell ...