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