Difference between revisions of "Manuals/calci/SUMPRODUCT"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
'''Array1, Array2.........''' - represents the arrays which first multiply and add. | '''Array1, Array2.........''' - represents the arrays which first multiply and add. | ||
| − | |||
| − | |||
<div id="1SpaceContent" class="zcontent" align="left"> | <div id="1SpaceContent" class="zcontent" align="left"> | ||
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 id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> | ||
| Line 65: | Line 59: | ||
| class=" " | 8 | | class=" " | 8 | ||
| class=" SelectTD ChangeBGColor SelectTD" | | | class=" SelectTD ChangeBGColor SelectTD" | | ||
| − | <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area." | + | <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area."> |
| class=" " | | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| Line 91: | Line 85: | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| − | |||
Revision as of 11:37, 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 |