Manuals/calci/DAVERAGE - Revision history

Devika at 19:44, 24 August 2018

2018-08-24T19:44:53Z

Devika at 22:05, 3 August 2018

2018-08-03T22:05:39Z

Devika at 22:03, 3 August 2018

2018-08-03T22:03:33Z

Jayaram at 11:23, 14 March 2017

2017-03-14T11:23:42Z

Swapna: /* Examples */

2015-10-06T22:08:00Z

Examples

Swapna: /* Examples */

2015-10-06T22:03:22Z

Examples

Swapna at 15:34, 6 October 2015

2015-10-06T15:34:26Z

Swapna at 19:51, 15 April 2015

2015-04-15T19:51:21Z

Swapna: /* Description */

2013-11-24T20:55:32Z

Description

Swapna at 21:55, 23 November 2013

2013-11-23T21:55:42Z

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''DAVERAGE (Array,Field,Criteria)'''</div><br/>
 *Where 'Array' is the range of cells that makes up the list or database
 *'Field' shows which column is used in the function and
 *'Criteria' is the range of cells that contains the specified criteria.
+**DAVERAGE(), returns the average of selected database entries.
 == Description ==

@@ Line 7: / Line 7: @@
 *'Criteria' is the range of cells that contains the specified criteria.
-*DAVERAGE() averages the values in a column of a list or database that match the specified criteria.
+*DAVERAGE(), returns the average of selected database entries.
 == Description ==

@@ Line 1: / Line 1: @@
-= DAVERAGE(database,field,criteria)=
+<div style="font-size:30px">'''DAVERAGE (Array,Field,Criteria)'''</div><br/>
-*Where 'database' is the range of cells that makes up the list or database
+*Where 'Array' is the range of cells that makes up the list or database
-*'field' shows which column is used in the function and
+*'Field' shows which column is used in the function and
-*'criteria' is the range of cells that contains the specified criteria.
+*'Criteria' is the range of cells that contains the specified criteria.
 *DAVERAGE() averages the values in a column of a list or database that match the specified criteria.
@@ Line 11: / Line 11: @@
 == Description ==
-DAVERAGE(database, field, criteria)
+DAVERAGE (Array,Field,Criteria)
 It averages the values in a column of a list or database that match the specified condition.
-* A 'field' argument can be expressed as "Price" (a column name) or 3 (position of column number).
+* A 'Field' argument can be expressed as "Price" (a column name) or 3 (position of column number).
 *Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.

← Older revision		Revision as of 11:23, 14 March 2017
Line 110:		Line 110:
	*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]		*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]
	*[http://en.wikipedia.org/wiki/Aggregate_function DAVERAGE]		*[http://en.wikipedia.org/wiki/Aggregate_function DAVERAGE]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 90: / Line 90: @@
-= DAVERAGE(A3:D7,"Price",A1:B2)  : Calculates the average price of Pens in the range A3 to D7, for the cells with Quantity>10. Returns '''66.66499999999999''' as a result.
+= DAVERAGE(A3:D7,"Price",A1:B2)  : Calculates the average price of Pens in the range A3 to D7, for the cells with Quantity>10. <br>Returns '''66.66499999999999''' as a result.
-= DAVERAGE(A3:D7,2,A1:B2)  : Calculates the average number of Pens in the range A3 to D7, for the cells with Quantity>10. Returns '''21''' as a result.
+= DAVERAGE(A3:D7,2,A1:B2)  : Calculates the average number of Pens in the range A3 to D7, for the cells with Quantity>10. <br>Returns '''21''' as a result.
-= DAVERAGE(A3:D7,"Quantity",A3:D7) : Calculates the average number of all items in the range A3 to D7. Returns '''21.75''' as a result.
+= DAVERAGE(A3:D7,"Quantity",A3:D7) : Calculates the average number of all items in the range A3 to D7. <br>Returns '''21.75''' as a result.
-= DAVERAGE(A3:D7,4,A3:D7) : Calculates the average of percentage profit of all the items in the range A3 to D7. Returns '''3''' as a result.
+= DAVERAGE(A3:D7,4,A3:D7) : Calculates the average of percentage profit of all the items in the range A3 to D7. <br>Returns '''3''' as a result.
 == Related Videos ==

@@ Line 27: / Line 27: @@
 == Examples ==
-Consider the following table with Stationary Items, Quantity, Price and Percentage Profit.
+Consider the following table using ZCalci with Stationary Items, Quantity, Price and Percentage Profit.
 <div id="4SpaceContent" class="zcontent" align="left">
@@ Line 33: / Line 33: @@
 {| id="TABLE2" class="SpreadSheet blue"
 |- class="even"
 | class="sshl_f" | '''Item'''
 | class="sshl_f" | '''Quantity'''
@@ Line 38: / Line 46: @@
 | class="sshl_f" | '''Profit'''
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Pen
 | class="sshl_f" | &gt;10
@@ Line 44: / Line 53: @@
 | class="ssh1_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | '''Item'''
 | class="sshl_f" | '''Quantity'''
@@ Line 50: / Line 60: @@
 | class="sshl_f" | '''Profit'''
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Pen
 | class="sshl_f" | 12
@@ Line 56: / Line 67: @@
 | class="sshl_f" | 2
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Pencil
 | class="sshl_f" | 20
@@ Line 62: / Line 74: @@
 | class="sshl_f" | 1
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Books
 | class="sshl_f" | 25
@@ Line 68: / Line 81: @@
 | class="ssh1_f" | 5
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Pen
 | class="sshl_f" | 30

← Older revision		Revision as of 19:51, 15 April 2015
Line 83:		Line 83:

	= DAVERAGE(A3:D7,4,A3:D7) : Calculates the average of percentage profit of all the items in the range A3 to D7. ''Returns 3'' as a result.		= DAVERAGE(A3:D7,4,A3:D7) : Calculates the average of percentage profit of all the items in the range A3 to D7. ''Returns 3'' as a result.
		+
		+	== Related Videos ==
		+	{{#ev:youtube\|-eYn-c8UIjw\|280\|center\|DAVERAGE}}

	== See Also ==		== See Also ==

← Older revision		Revision as of 20:55, 24 November 2013
Line 20:		Line 20:

	*The Criteria columns should not overlap the list of data.		*The Criteria columns should not overlap the list of data.
−
−	*To calculate the average of all values of certain column, the database range should be used as a criteria argument.
−	~~For Example considering below table,~~
−
−	~~DAVERAGE(A3:D7,"Profit",A3:D7) ''returns 3'' as a result.~~

	*DCOUNT() can be used to count the cells having numbers from a list or database that match a specified criteria.		*DCOUNT() can be used to count the cells having numbers from a list or database that match a specified criteria.

← Older revision		Revision as of 21:55, 23 November 2013
Line 29:		Line 29:

	*DCOUNTA() can be used to count the number of non-blank cells from a list of database that match a specified criteria.		*DCOUNTA() can be used to count the number of non-blank cells from a list of database that match a specified criteria.
−
−	~~<!--~~
−	~~<div id="8SpaceContent" class="zcontent" align="left">~~
−
−	~~<u>[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">Let's see an example</font>]</u>~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">C1 C2 C3 C4 </font></u>]~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R1 Stationary Items Count Price Profit</font></u>]~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R2 Pen 10 40 10</font></u>]~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R3 Pencil 20 30 15</font></u>]~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">R4 Books 15 75 20</font></u>]~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~<font color="#0000ff"><br /></font>~~
−
−	~~[javascript:ToggleDiv('divExpCollAsst_4') <u><font color="#0000ff">I.e. =DAVERAGE(C1R1:C4R6,3,C1R1:C4R4) is 48.333(average price of the items)</font></u>]~~
−
−	~~</div>~~
−	~~-->~~

	== Examples ==		== Examples ==