Difference between revisions of "Manuals/calci/SUMPRODUCT"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
==Examples== | ==Examples== | ||
<div id="8SpaceContent" class="zcontent" align="left"> | <div id="8SpaceContent" class="zcontent" align="left"> | ||
| − | |||
Lets see an example in (Column3, Row1) <nowiki>=SUMPRODUCT(R1C1:R3C2,R4C1: R6C2)</nowiki> | Lets see an example in (Column3, Row1) <nowiki>=SUMPRODUCT(R1C1:R3C2,R4C1: R6C2)</nowiki> | ||
SUMPRODUCT returns 298. | SUMPRODUCT returns 298. | ||
| + | </div> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
Revision as of 12:50, 18 November 2013
SUMPRODUCT(Array1, Array2...............)
- where, Array1, Array2......... - represents the arrays which first multiply and add.
Description
It returns the sum of multiplies corresponding values in the arrays.
Remarks
If Array1,Array2....... have different number of values, SUMPRODUCT returns the #ERROR.
Examples
Lets see an example in (Column3, Row1) =SUMPRODUCT(R1C1:R3C2,R4C1: R6C2) SUMPRODUCT returns 298.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 7 | 298 | |
| Row2 | 2 | 8 | ||
| Row3 | 3 | 9 | ||
| Row4 | 4 | 10 | ||
| Row5 | 5 | 11 | ||
| Row6 | 6 | 12 |