Manuals/calci/DCOUNTA - Revision history

Devika at 19:46, 24 August 2018

2018-08-24T19:46:35Z

Devika at 22:19, 3 August 2018

2018-08-03T22:19:10Z

Devika at 22:17, 3 August 2018

2018-08-03T22:17:51Z

Jayaram at 11:24, 14 March 2017

2017-03-14T11:24:18Z

Swapna: /* Examples */

2015-10-08T19:09:12Z

Examples

Swapna: /* Examples */

2015-10-08T19:02:48Z

Examples

Swapna at 20:24, 15 April 2015

2015-04-15T20:24:30Z

Swapna at 19:58, 15 April 2015

2015-04-15T19:58:09Z

Swapna at 15:11, 8 November 2013

2013-11-08T15:11:49Z

Swapna at 01:14, 8 November 2013

2013-11-08T01:14:11Z

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''DCOUNTA (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.
+**DCOUNTA() Counts nonblank cells in a database.
 == Description ==

← Older revision		Revision as of 22:19, 3 August 2018
Line 1:		Line 1:
	<div style="font-size:30px">'''DCOUNTA (Array,Field,Criteria)'''</div><br/>		<div style="font-size:30px">'''DCOUNTA (Array,Field,Criteria)'''</div><br/>
−

	*Where 'Array' 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

@@ Line 1: / Line 1: @@
-=DCOUNTA(database, field, criteria)=
+<div style="font-size:30px">'''DCOUNTA (Array,Field,Criteria)'''</div><br/>
-*'field' shows which column is used in the function and
+*Where 'Array' is the range of cells that makes up the list or database
-*'criteria' is the range of cells that contains the specified criteria.
+*'Field' shows which column is used in the function and
-*DCOUNTA() counts the non-blank cells in the column of a list or database that match the specified criteria.
+*'Criteria' is the range of cells that contains the specified criteria.
 == Description ==
-DCOUNTA(database, field, criteria)
+DCOUNTA (Array,Field,Criteria)
 It counts the nonblank cells in a column of a list or database that match conditions that we specify.
-*The argument 'field' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
+*The argument 'Field' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
 * A 'column name' in quotes (e.g "Salary") or 'column number' (e.g 3, if Salary is 3rd column) can be used as 'field' argument.

← Older revision		Revision as of 11:24, 14 March 2017
Line 123:		Line 123:
	*[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 DCOUNTA]		*[http://en.wikipedia.org/wiki/Aggregate_function DCOUNTA]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 102: / Line 102: @@
 |}
-=DCOUNTA(A4:C10,"Salary",A1:C2)   : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000. ''Displays 3'' as a result.
+=DCOUNTA(A4:C10,"Salary",A1:C2)   : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000. <br>Displays '''3''' as a result.
-=DCOUNTA(A4:C10,"Salary",D1:D2)   : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age>32.''Displays 4'' as a result.
+=DCOUNTA(A4:C10,"Salary",D1:D2)   : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age>32.<br>Displays '''4''' as a result.
 There are 5 cells in Salary column with Employee Age>32, but Salary field for Employee Bob is blank. Hence result displayed is '4'.
-=DCOUNTA(A4:C10,3,D1:D2)          : Counts the number of non-blank cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age>32.''Displays 4'' as a result.
+=DCOUNTA(A4:C10,3,D1:D2)          : Counts the number of non-blank cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age>32.<br>Displays '''4''' as a result.
 There are 5 cells in Salary column with Employee Age>32, but Salary field for Employee Bob is blank. Hence result displayed is '4'.

@@ Line 30: / Line 30: @@
 Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.
-UNIQa64c61183a55bdea-item-4--QINU
+<div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class="sshl_f " | '''Name'''
 | class="sshl_f" | '''Age'''
 | class="sshl_f" | '''Salary'''
 | class="sshl_f" | '''Age'''
-|- class="odd"
+|- class="even"
 | class="sshl_f" |
 | class="sshl_f" | &lt;40
@@ Line 45: / Line 52: @@
 | class="sshl_fSelectTD SelectTD " | &gt;32
 <div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-|- class="even"
+|- class="odd"
 | class="sshl_f" |
 | class="sshl_f " | &gt;30
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f   " | '''Name'''
 | class="sshl_f" | '''Age'''
 | class="sshl_f" | '''Salary'''
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | John
 | class="sshl_f" | 34
 | class="sshl_f" | 5500
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Bill
 | class="sshl_f" | 35
 | class="sshl_f" | 6500
 | class="sshl_f  " |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Clark
 | class="sshl_f" | 29
 | class="sshl_f" | 7000
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Bob
 | class="sshl_f" | 45
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Susan
 | class="sshl_f" | 37
 | class="sshl_f" | 4000
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Jill
 | class="sshl_f" | 45

@@ Line 97: / Line 97: @@
 There are 5 cells in Salary column with Employee Age>32, but Salary field for Employee Bob is blank. Hence result displayed is '4'.
-== See Also ==
+== Related Videos ==
 {{#ev:youtube|D_1-SavHX-M|280|center|DCOUNTA}}

@@ Line 1: / Line 1: @@
-=DCOUNTA(db, fld, cri)=
+=DCOUNTA(database, field, criteria)=
-*Where 'db' is the range of cells that makes up the list or database
+*Where 'database' is the range of cells that makes up the list or database
-*'fld' shows which column is used in the function and
+*'field' shows which column is used in the function and
-*'cri' is the range of cells that contains the specified criteria.
+*'criteria' is the range of cells that contains the specified criteria.
 *DCOUNTA() counts the non-blank cells in the column of a list or database that match the specified criteria.
@@ Line 11: / Line 11: @@
 == Description ==
-DCOUNTA(db, fld, cri)
+DCOUNTA(database, field, criteria)
-It counts the nonblank cells in a column of a list or database that match conditions that we specify.</font></font></font>
+It counts the nonblank cells in a column of a list or database that match conditions that we specify.
-*The argument 'fld' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
+*The argument 'field' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
-* A 'column name' in quotes (e.g "Salary") or 'column number' (e.g 3, if Salary is 3rd column) can be used as 'fld' argument.
+* A 'column name' in quotes (e.g "Salary") or 'column number' (e.g 3, if Salary is 3rd column) can be used as 'field' argument.
 *Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.