Manuals/calci/SUMPRODUCT - Revision history

Devika at 21:47, 21 August 2018

2018-08-21T21:47:06Z

Devika at 21:58, 3 July 2018

2018-07-03T21:58:37Z

Jayaram at 11:22, 13 March 2017

2017-03-13T11:22:45Z

Devika: /* Examples */

2015-10-10T16:06:58Z

Examples

Swapna: /* Related Videos */

2015-04-16T19:17:09Z

Swapna at 19:15, 16 April 2015

2015-04-16T19:15:31Z

Swapna at 22:26, 21 February 2014

2014-02-21T22:26:07Z

Swapna at 22:25, 21 February 2014

2014-02-21T22:25:14Z

Swapna at 22:22, 21 February 2014

2014-02-21T22:22:33Z

Writer1 at 18:50, 18 November 2013

2013-11-18T18:50:44Z

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''SUMPRODUCT()'''</div><br/>
 *Parameters are arrays whose values are to be multiplied and then added.
+**SUMPRODUCT(), returns the sum of the products of corresponding array components.
 == Description ==

@@ Line 1: / Line 1: @@
-=SUMPRODUCT(arr1, arr2, .....)=
+<div style="font-size:30px">'''SUMPRODUCT()'''</div><br/>
-*where <math>arr1, arr2, .....</math> are arrays whose values are to be multiplied and then added.
+SUMPRODUCT(), returns the sum of the products of corresponding array components.
 == Description ==
-SUMPRODUCT(arr1, arr2, .....)
+SUMPRODUCT()
 *This function first multiplies the corresponding values in respective arrays and then adds the product values to display the result.
-*Argument <math>arr1, arr2, .....</math> are the numbers to be multiplied and then added.
+*Argument  are the numbers to be multiplied and then added.
-*<math>arr1, arr2, .....</math> should be of same dimensions, else Calci displays #N/A error message.
+*Parameters should be of same dimensions, else Calci displays #N/A error message.
 *Non-numeric values are considered zero (0).

← Older revision		Revision as of 11:22, 13 March 2017
Line 79:		Line 79:
	*[http://en.wikipedia.org/wiki/Product_(mathematics) Product]		*[http://en.wikipedia.org/wiki/Product_(mathematics) Product]
	*[http://en.wikipedia.org/wiki/Summation Summation]		*[http://en.wikipedia.org/wiki/Summation Summation]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 64: / Line 64: @@
   =SUMPRODUCT(A2:B4,E2:F4) : Calculates SUMPRODUCT of Array1 and Array3 as <br />((1*-1)+(2*-2)+(3*-3)+(4*-4)+(5*-5)+(6*-6)). Returns '''-91''' as a result.
   =SUMPRODUCT(A2:B4,C2:D4,E2:F4) : Calculates SUMPRODUCT of Array1, Array2 and Array3 as <br />((1*7*-1)+(2*8*-2)+(3*9*-3)+(4*7*-4)+(5*8*-5)+(6*9*-6)). Returns '''-756''' as a result.
-  =SUMPRODUCT([2,6],[1.5,-2]) : Calculates ((2*1.5)+(6*-2)). Returns '''-3''' as a result.
+  =SUMPRODUCT([2,6],[1.5,-2]) : Calculates ((2*1.5)+(6*-2)). Returns '''-9''' as a result.
 ==Related Videos==

← Older revision		Revision as of 19:17, 16 April 2015
Line 67:		Line 67:

	==Related Videos==		==Related Videos==
		+
	{{#ev:youtube\|rwsX1KVhEnU\|280\|center\|SUMPRODUCT}}		{{#ev:youtube\|rwsX1KVhEnU\|280\|center\|SUMPRODUCT}}

@@ Line 62: / Line 62: @@
   =SUMPRODUCT(A2:B4,C2:D4) : Calculates SUMPRODUCT of Array1 and Array2 as ((1*7)+(2*8)+(3*9)+(4*7)+(5*8)+(6*9)). <br />Returns '''172''' as a result.
-  =SUMPRODUCT(A2:B4,E2:F4) : Calculates SUMPRODUCT of Array1 and Array3 as ((1*-1)+(2*-2)+(3*-3)+(4*-4)+(5*-5)+(6*-6)). <br />Returns '''-91''' as a result.
+  =SUMPRODUCT(A2:B4,E2:F4) : Calculates SUMPRODUCT of Array1 and Array3 as <br />((1*-1)+(2*-2)+(3*-3)+(4*-4)+(5*-5)+(6*-6)). Returns '''-91''' as a result.
-  =SUMPRODUCT(A2:B4,C2:D4,E2:F4) : Calculates SUMPRODUCT of Array1, Array2 and Array3 as ((1*7*-1)+(2*8*-2)+(3*9*-3)+(4*7*-4)+(5*8*-5)+(6*9*-6)). <br />Returns '''-756''' as a result.
+  =SUMPRODUCT(A2:B4,C2:D4,E2:F4) : Calculates SUMPRODUCT of Array1, Array2 and Array3 as <br />((1*7*-1)+(2*8*-2)+(3*9*-3)+(4*7*-4)+(5*8*-5)+(6*9*-6)). Returns '''-756''' as a result.
   =SUMPRODUCT([2,6],[1.5,-2]) : Calculates ((2*1.5)+(6*-2)). Returns '''-3''' as a result.

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''SUMPRODUCT'''(Array1, Array2...............)</div><br/>
+SUMPRODUCT() multiplies the corresponding array values and displays their sum as a result.
-==Description==
+SUMPRODUCT(arr1, arr2, .....)
-==Remarks==
+*This function first multiplies the corresponding values in respective arrays and then adds the product values to display the result.
-<div id="7SpaceContent" class="zcontent" align="left">If Array1,Array2....... have different number of values, SUMPRODUCT returns the #ERROR.</div>
+*Argument <math>arr1, arr2, .....</math> are the numbers to be multiplied and then added.
-==Examples==
+== Examples ==
-SUMPRODUCT returns 298.
+<div id="6SpaceContent" class="zcontent" align="left">
-<div id="2SpaceContent" class="zcontent" align="left">
+{| id="TABLE3" class="SpreadSheet blue"
-  {| id="TABLE3" class="SpreadSheet blue"
+|- class="odd"
-  |- class="even"
+| class="sshl_f" |1
-  | class=" " |
+| class="sshl_f" |4
-  | Column1
+| class="sshl_f" |7
-  | class="     " | Column2
+| class="sshl_f" |7
-  | class="     " | Column3
+| class="sshl_f" |-1
-  | Column4
+| class="sshl_f" |-4
-  |- class="odd"
-  | class=" " | Row1
+|- class="even"
-  | class=" " | 1
+| class="sshl_f" |2
-  | class=" " | 7
+| class="sshl_f" |5
-  | class="sshl_f" | 298
+| class="sshl_f" |8
-  | class=" " |
+| class="sshl_f" |8
-  |- class="even"
+| class="sshl_f" |-2
-  | class="  " | Row2
+| class="sshl_f" |-5
-  | class=" " | 2
-  | class=" " | 8
+|- class="odd"
-  | class="  SelectTD ChangeBGColor SelectTD" |
+| class="sshl_f" |3
-  | class=" " |
+| class="sshl_f" |6
-  |- class="odd"
+| class="sshl_f" |9
-  | Row3
+| class="sshl_f" |9
-  | class=" " | 3
+| class="sshl_f" |-3
-  | class=" " | 9
+| class="sshl_f" |-6
-  | class=" " |
-  | class=" " |
+|- class="even"
-  |- class="even"
+| class="sshl_f" |
-  | Row4
+| class="sshl_f" |
-  | class="                                                 sshl_f " | 4
+| class="sshl_f" |
-  | class=" " | 10
+| class="sshl_f" |
-  | class=" " |
+| class="sshl_f" |
-  | class=" " |
+| class="sshl_f" |
-  |- class="odd"
-  | class=" " | Row5
+|}
-  | class=" " | 5
-  | class=" " | 11
+ =SUMPRODUCT(A2:B4,C2:D4) : Calculates ((1*7)+(2*8)+(3*9)+(4*7)+(5*8)+(6*9)). <br />Returns '''172''' as a result.
-  | class=" " |
+ =SUMPRODUCT(A2:B4,E2:F4) : Calculates ((1*-1)+(2*-2)+(3*-3)+(4*-4)+(5*-5)+(6*-6)). <br />Returns '''-91''' as a result.
-  | class=" " |
+ =SUMPRODUCT(A2:B4,C2:D4,E2:F4) : Calculates ((1*7*-1)+(2*8*-2)+(3*9*-3)+(4*7*-4)+(5*8*-5)+(6*9*-6)). <br />Returns '''-756''' as a result.
-  |- class="even"
+ =SUMPRODUCT([2,6],[1.5,-2]) : Calculates ((2*1.5)+(6*-2)). Returns '''-3''' as a result.
-  | Row6
-  | class=" " | 6
+==See Also==
-  | class=" " | 12
-  | class=" " |
+*[[Manuals/calci/SUM | SUM]]
-  | class=" " |
+*[[Manuals/calci/PRODUCT | PRODUCT]]
-</div>

@@ Line 14: / Line 14: @@
 <div id="8SpaceContent" class="zcontent" align="left">
 Lets see an example in (Column3, Row1) <nowiki>=SUMPRODUCT(R1C1:R3C2,R4C1: R6C2)</nowiki>
 SUMPRODUCT returns 298.
 </div>