The
SUMPRODUCT() function returns sum of
the products of array components.
- The syntax for
the function is SUMPRODUCT (array1,
array2,.... array_n).
The
arguments for the function "array1,
array2,.... array_n" can
be a series of up to 30 arrays, referenced
ranges of cells or named ranges.
The SUMPRODUCT
function multiplies corosponding components
of each array and then finds
the sum of these products.
- For
example: SUMPRODUCT({3,8,4},{10,20,30})
= 310.
This is
beacause the 1st componet of of the
1st row in each array is multiplied,
then the 2nd componet of the 1st row
is multiplied, then the third component.
Finally the results of these products
are added to give the a cumulative
total. i.e. (3*10)+(8*20)+(4*30) =
(30)+(160)+(120) = 310.
|
