Difference between revisions of "Manuals/calci/SUMPRODUCT"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
<div id="8SpaceContent" class="zcontent" align="left"> | <div id="8SpaceContent" class="zcontent" align="left"> | ||
| − | Lets see an example in (Column3, Row1) | + | Lets see an example in (Column3, Row1) <nowiki>=SUMPRODUCT(R1C1:R3C2,R4C1: R6C2)</nowiki> |
| + | SUMPRODUCT returns 298. | ||
| − | |||
| − | SUMPRODUCT | + | Consider an another example : =SUMPRODUCT(R1C1:R3C2,R4C1: R5C2) |
| + | |||
| + | SUMPRODUCT returns the #ERROR. | ||
</div> | </div> | ||
Revision as of 13:49, 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.
Consider an another example : =SUMPRODUCT(R1C1:R3C2,R4C1: R5C2)
SUMPRODUCT returns the #ERROR.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 7 | 298 | |
| Row2 | 2 | 8 | ||
| Row3 | 3 | 9 | ||
| Row4 | 4 | 10 | ||
| Row5 | 5 | 11 | ||
| Row6 | 6 | 12 |