Difference between revisions of "Manuals/calci/SUMPRODUCT"

Revision as of 10: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

@@ Line 7: / Line 7: @@
 '''Array1, Array2.........''' - represents the arrays which first multiply and add.
-</div>
-----
 <div id="1SpaceContent" class="zcontent" align="left">
 It returns the sum of multiplies corresponding values in the arrays.
-</div>
-----
 <div id="7SpaceContent" class="zcontent" align="left">
 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">
@@ Line 65: / Line 59: @@
 | class=" " | 8
 | 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.">[[Image:copy-cube.gif]]  </div>
+<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="odd"
@@ Line 91: / Line 85: @@
 | class=" " |
 | class=" " |
-|