Manuals/calci/COUNTA - Revision history

Devika at 21:36, 7 August 2018

2018-08-07T21:36:40Z

2018-06-06T17:34:16Z

2017-03-13T05:59:48Z

2017-03-09T11:01:09Z

2015-10-05T01:45:00Z

2015-06-04T18:33:38Z

2015-04-15T04:51:56Z

2015-04-15T04:50:11Z

2013-11-06T14:35:10Z

2013-11-06T00:18:02Z

@@ Line 1: / Line 1: @@
-=COUNTA ()=
+<div style="font-size:30px">'''COUNTA ()'''</div><br/>
 *Parameters are any arguments.
+**COUNTA(), counts how many values are in the list of arguments.
 *Empty cells and text values in the array or reference are ignored.
@@ Line 10: / Line 7: @@
 COUNTA()
-Consider columns A1 to A8 contain 3 numbers. COUNTA(A1:A8) ''returns 3 '' as a result.
+*Consider columns A1 to A8 contain 3 numbers. COUNTA(A1:A8) ''returns 3 '' as a result.
+*COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
-COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
+*COUNTA(1..100,5,TRUE) ''returns 102'' as a result.  Logical value 'TRUE' is also counted.
+*COUNTA(1..100,5,TRUE,"ONE") ''returns 103'' as a result.
 * Arguments can be numbers, dates, text representation of a numbers, logical values, error values or empty text("").
 * Empty cells and text values are not counted.
 * COUNT() can be used to count the number of cells of all type of values excluding logical values, text and error values.
 * COUNTIF() can be used to count the number of cells that satisfy the given criteria.

@@ Line 1: / Line 1: @@
-=COUNTA (v1, v2...)=
+=COUNTA ()=
-*Where v1, v2….   are arguments.
+*Parameters are any arguments.
 *COUNTA() returns the count of non-empty cells, and values within the list of arguments.
@@ Line 8: / Line 8: @@
 == Description ==
-COUNTA(v1,v2....)
+COUNTA()
 Consider columns A1 to A8 contain 3 numbers. COUNTA(A1:A8) ''returns 3 '' as a result.
@@ Line 29: / Line 29: @@
 ==ZOS==
-*The syntax to calculate COUNTA in ZOS is <math>COUNTA(v1, v2...)</math>
+*The syntax to calculate COUNTA in ZOS is <math>COUNTA()</math>
-**<math>v1, v2...</math> are arguments.
+**Parameter are any arguments.
 *For e.g., COUNTA(10,12,17,true,false)

← Older revision		Revision as of 05:59, 13 March 2017
Line 106:		Line 106:


−	[[Z_API_Functions \| List of Main Z Functions]]	+	*[[Z_API_Functions \| List of Main Z Functions]]

−	[[ Z3 \| Z3 home ]]	+	*[[ Z3 \| Z3 home ]]

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

@@ Line 14: / Line 14: @@
 COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
-COUNT(1..100,5,TRUE) ''returns 102'' as a result.  Logical value 'TRUE' is also counted.
+COUNTA(1..100,5,TRUE,"ONE") ''returns 103'' as a result.
@@ Line 30: / Line 29: @@
 ==ZOS==
-*The syntax is to calculate COUNTA in ZOS is <math>COUNTA(v1, v2...)</math>
+*The syntax to calculate COUNTA in ZOS is <math>COUNTA(v1, v2...)</math>
 **<math>v1, v2...</math> are arguments.
 *For e.g., COUNTA(10,12,17,true,false)

← Older revision		Revision as of 18:33, 4 June 2015
Line 27:		Line 27:

	* COUNTIF() can be used to count the number of cells that satisfy the given criteria.		* COUNTIF() can be used to count the number of cells that satisfy the given criteria.
		+
		+	==ZOS==
		+
		+	*The syntax is to calculate COUNTA in ZOS is <math>COUNTA(v1, v2...)</math>
		+	**<math>v1, v2...</math> are arguments.
		+	*For e.g., COUNTA(10,12,17,true,false)

	== Examples ==		== Examples ==

@@ Line 86: / Line 86: @@
 == Related Videos==
 {{#ev:youtube|Ni1GE-Cuijg}}
 == See Also ==

@@ Line 84: / Line 84: @@
 =COUNTA(B1:B5,"A",11)   : Counts the number of cells that contain numbers in the cells B1 to B5 , text value "A" and number '11', ''returns 4'' as a result.
 </div>
 == See Also ==

← Older revision		Revision as of 14:35, 6 November 2013
Line 13:		Line 13:

	COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.		COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
		+
		+
		+	COUNT(1..100,5,TRUE) ''returns 102'' as a result. Logical value 'TRUE' is also counted.
		+
		+	COUNT(1..100,5,TRUE,"ONE") ''returns 103'' as a result.
		+

	* Arguments can be numbers, dates, text representation of a numbers, logical values, error values or empty text("").		* Arguments can be numbers, dates, text representation of a numbers, logical values, error values or empty text("").

@@ Line 29: / Line 29: @@
 {| id="TABLE3" class="SpreadSheet blue"
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Sales
 | class="sshl_f" | 4
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | 23/8/2009
 | class="sshl_f" | 3
@@ Line 40: / Line 40: @@
 <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="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" |
 | class="sshl_f" |
 | class="sshl_f" |
 | class="sshl_f" |0
-|- class="even"
+|- class="odd"
 | class="sshl_f" | 22
 | class="sshl_f" |
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | 52.69
 | class="sshl_f" |
 | class="sshl_f" |
 | 0
-|- class="even"
+|- class="odd"
 | class="sshl_f" | TRUE
 | class="sshl_f  " |
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | #NUM!
 | class="sshl_f" |