Manuals/calci/SUMIF - Revision history

Devika: /* Related Videos */

2018-11-21T21:35:44Z

Devika at 21:45, 21 August 2018

2018-08-21T21:45:57Z

Devika at 21:54, 3 July 2018

2018-07-03T21:54:44Z

Devika at 21:53, 3 July 2018

2018-07-03T21:53:35Z

Jayaram at 11:22, 13 March 2017

2017-03-13T11:22:29Z

Swapna at 17:50, 16 April 2015

2015-04-16T17:50:13Z

Swapna: /* Examples */

2014-02-20T22:03:49Z

Examples

Swapna at 22:00, 20 February 2014

2014-02-20T22:00:59Z

Jayaram at 16:25, 18 November 2013

2013-11-18T16:25:34Z

Jayaram at 17:39, 15 November 2013

2013-11-15T17:39:02Z

@@ Line 76: / Line 76: @@
 ==Related Videos==
-{{#ev:youtube|FlVuD39001g|280|center|SUMIF}}
+{{#ev:youtube|v=V1acCft4fzY|280|center|SUMIF}}
 ==See Also==

@@ Line 4: / Line 4: @@
 *<math>Condition</math> is a condition to evaluate in the form of a number, expression or text, and
 *<math>SumArray</math> is the actual range of cells to be added.
+**SUMIF(), adds the cells specified by a given criteria.
 == Description ==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''SUMIF (Array,Condition,SumArray)'''</div><br/>
 where
 *<math>Array</math> is the range of cells that is evaluated by the specified criteria,
@@ Line 7: / Line 5: @@
 *<math>SumArray</math> is the actual range of cells to be added.
-SUMIF() calculates the sum of values in the given range if the specified criteria is satisfied.
+SUMIF(), adds the cells specified by a given criteria.
 == Description ==

@@ Line 1: / Line 1: @@
-=SUMIF(CriRange, Criteria, SumRange)=
+<div style="font-size:30px">'''SUMIF (Array,Condition,SumArray)'''</div><br/>
 where
-*<math>CriRange</math> is the range of cells that is evaluated by the specified criteria,
+*<math>Array</math> is the range of cells that is evaluated by the specified criteria,
-*<math>Criteria</math> is a condition to evaluate in the form of a number, expression or text, and
+*<math>Condition</math> is a condition to evaluate in the form of a number, expression or text, and
-*<math>SumRange</math> is the actual range of cells to be added.
+*<math>SumArray</math> is the actual range of cells to be added.
 SUMIF() calculates the sum of values in the given range if the specified criteria is satisfied.
@@ Line 10: / Line 11: @@
 == Description ==
-SUMIF(CriRange, Criteria, SumRange)
+SUMIF (Array,Condition,SumArray)
 For Example,
@@ Line 18: / Line 19: @@
 In above example, Calci checks for the values > 15 in first array (20 and 30) and returns the sum of corresponding values in second array (60 and 70) and displays '''130''' as a result.
-*Blank values in <math>CriRange</math> are ignored.
+*Blank values in <math>Array</math> are ignored.
-*<math>Criteria</math> can be in the form of a number, expression, a cell reference, function or text. Expression, function or text criteria should be written in double quotation marks (e.g. ">30" or "A2+A3<100" or "Banana").
+*<math>Condition</math> can be in the form of a number, expression, a cell reference, function or text. Expression, function or text criteria should be written in double quotation marks (e.g. ">30" or "A2+A3<100" or "Banana").
-*Argument <math>SumRange</math> is an optional. It specifies the range of cells to add if the mentioned condition is satisfied.
+*Argument <math>SumArray</math> is an optional. It specifies the range of cells to add if the mentioned condition is satisfied.
-*If <math>SumRange</math> is omitted, Calci adds the values in the same range for which criteria is applied.
+*If <math>SumArray</math> is omitted, Calci adds the values in the same range for which criteria is applied.
-*<math>SumRange</math> and <math>CriRange</math> can be of different sizes. The actual cell to be added are determined by using upper leftmost cell in <math>SumRange</math> as the beginning cell, till the cells corresponding in size and shape to <math>CriRange</math>.
+*<math>SumArray</math> and <math>Array</math> can be of different sizes. The actual cell to be added are determined by using upper leftmost cell in <math>SumArray</math> as the beginning cell, till the cells corresponding in size and shape to <math>Array</math>.
-*If <math>Criteria</math> is not satisfied, Calci displays zero (0) as a result.
+*If <math>Condition</math> is not satisfied, Calci displays zero (0) as a result.
 == Examples ==

← Older revision		Revision as of 11:22, 13 March 2017
Line 87:		Line 87:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Summation SUM]		*[http://en.wikipedia.org/wiki/Summation SUM]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 73: / Line 73: @@
 |}
-  =SUMIF(B2:B6,"10",C2:C6) : Checks for the fruits with Quantity equal to '10' and adds the corresponding prices. Returns '''30''' as a result.
+  =SUMIF(B2:B6,"10",C2:C6) : Checks for the fruits with Quantity equal to '10' and adds the corresponding prices. <br />Returns '''30''' as a result.
   =SUMIF(B2:B6,">10") : Adds up the quantity of fruits that are greater than '10'. Returns '''50''' as a result.
   =SUMIF(A2:A6,"=Pear",C2:C6) : checks for the Pear fruit in the list and adds the price. Returns '''20''' as a result.

@@ Line 1: / Line 1: @@
-<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
+=SUMIF(CriRange, Criteria, SumRange)=
-'''SUMIF'''(a1:a4, '''c''', R)
+where
-'''a1:a4'''   is the range of cells that you want evaluated by the given criteria.
+SUMIF() calculates the sum of values in the given range if the specified criteria is satisfied.
-'''C''' is the criteria in the form of a number, expression, or text
+== Description ==
-'''R'''   are the actual cells to add
+SUMIF(CriRange, Criteria, SumRange)
-C1             C2
+For Example,
-R1          1000           100
+SUMIF([10,20,30],">15", [50,60,70]) ''returns 130''
-R2           9000           300
+In above example, Calci checks for the values > 15 in first array (20 and 30) and returns the sum of corresponding values in second array (60 and 70) and displays '''130''' as a result.
-R3           8000           250
+*Blank values in <math>CriRange</math> are ignored.
-R4            12000        500
+== Examples ==
-<nowiki>=SUMIF(C1R1:C1R4,"&gt;5000",C2R1:C2R4) is 1050</nowiki>
+<div id="6SpaceContent" class="zcontent" align="left">
-<div id="1SpaceContent" class="zcontent" align="left"><div>
+{| id="TABLE3" class="SpreadSheet blue"
 |- class="odd"
-| class=" " | Row1
+| class="sshl_f" | Orange
-| class="sshl_f " | 1000
+| class="sshl_f" | 20
-| class="sshl_f " | 100
+| class="sshl_f" | $10
 | class="sshl_f" |
-| class="sshl_f" |
 |- class="even"
-| class="  " | Row2
+| class="sshl_f" | Apple
-| class="sshl_f" | 9000
+| class="sshl_f" | 10
-| class="sshl_f" | 300
+| class="sshl_f" | $15
 | class="sshl_f" |
-| class="sshl_f" |
 |- class="odd"
-| Row3
+| class="sshl_f" | Banana
-| class="sshl_f" | 8000
+| class="sshl_f" | 15
-| class="sshl_f" | 250
+| class="sshl_f" | $5
 | class="sshl_f" |
 | class="sshl_f" |
 |- class="even"
-| Row4
+| class="sshl_f" | Mango
-| class=" " | 12000
+| class="sshl_f" | 10
-| class="sshl_f " | 500
+| class="sshl_f" | $15
 | class="sshl_f" |
 | class="sshl_f" |
 |- class="odd"
-| class=" " | Row5
+| class="sshl_f" | Pear
-| class="sshl_f" |
+| class="sshl_f" | 15
-| class="sshl_f" | 1050
+| class="sshl_f" | $20
 | class="sshl_f" |
-| class="sshl_f" |
 |- class="even"
-| Row6
+| class="sshl_f" |
 | class="sshl_f" |
 | class="sshl_f" |
 | class="sshl_f" |
 |}

← Older revision		Revision as of 16:25, 18 November 2013
Line 68:		Line 68:
	\| class="sshl_f" \|		\| class="sshl_f" \|
	\|}		\|}
−
−	~~<div align="left"></div>''''''</div></div>~~
−	~~----~~
−	~~</div></div></div></div></div></div></div></div></div>~~