Difference between revisions of "Manuals/calci/SUMPRODUCT"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | + | <div style="font-size:30px">'''SUMPRODUCT'''(Array1, Array2...............)</div><br/> | |
| + | *where, '''Array1, Array2.........''' - represents the arrays which first multiply and add. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| + | ==Description== | ||
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"> | + | ==Remarks== |
| + | <div id="7SpaceContent" class="zcontent" align="left">If Array1,Array2....... have different number of values, SUMPRODUCT returns the #ERROR.</div> | ||
| − | + | ==Examples== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="8SpaceContent" class="zcontent" align="left"> | <div id="8SpaceContent" class="zcontent" align="left"> | ||
| Line 31: | Line 21: | ||
</div> | </div> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
Revision as of 12:40, 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 |