Manuals/calci/COUNT - Revision history

Devika at 21:29, 7 August 2018

2018-08-07T21:29:52Z

2018-08-07T21:29:32Z

2018-08-07T21:27:13Z

2018-08-07T21:26:59Z

2017-03-13T05:59:36Z

2017-03-09T11:00:51Z

2015-06-04T18:23:37Z

ZOS

2015-06-04T18:18:45Z

2015-04-15T19:37:45Z

2013-11-06T14:32:11Z

@@ Line 2: / Line 2: @@
 *Parameters are any values.
 **COUNT(), counts how many numbers are in the list of arguments.
 == Description ==

@@ Line 3: / Line 3: @@
 *Parameters are any values.
-*COUNT(), counts how many numbers are in the list of arguments.
+**COUNT(), counts how many numbers are in the list of arguments.
 == Description ==
 COUNT()
-Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result.
+*Logical values, text, error values are ignored.
+*Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result.
 * The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.
 * Any error values, text, empty cells or logical values are not counted.
 * COUNTA() can be used to count the number of cells with empty text("") or error values.
 * COUNTIF() can be used to count the number of cells that satisfy the given criteria.

← Older revision		Revision as of 21:27, 7 August 2018
Line 1:		Line 1:
−	~~=COUNT(v1, v2...)=~~
	<div style="font-size:30px">'''COUNT () '''</div><br/>		<div style="font-size:30px">'''COUNT () '''</div><br/>

@@ Line 1: / Line 1: @@
 =COUNT(v1, v2...)=
-*Where v1, v2 ...   are the arguments.
+<div style="font-size:30px">'''COUNT () '''</div><br/>
-*COUNT() returns the number of cells that contain numbers, and also numbers within the list of arguments.
+*Parameters are any values.
 *Arguments can be numbers, dates or text representation of numbers.
@@ Line 9: / Line 11: @@
 == Description ==
-COUNT(v1,v2...)
+COUNT()
 Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result.
@@ Line 30: / Line 32: @@
 ==ZOS==
-*The syntax is to calculate COUNT in ZOS is <math>COUNT(v1,v2,...)</math>
+*The syntax is to calculate COUNT in ZOS is <math>COUNT()</math>
-**<math>v1, v2 ...</math>   are the arguments.
+**Parameters  are any values.
 *For e.g., COUNT(10,12,18,19,20,25)
 *COUNT(40..55)

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


−	[[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:00, 9 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 COUNT]		*[http://en.wikipedia.org/wiki/Aggregate_function COUNT]
		+
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

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

	* 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 COUNT in ZOS is <math>COUNT(v1,v2,...)</math>
		+	**<math>v1, v2 ...</math> are the arguments.
		+

	== Examples ==		== Examples ==

← Older revision		Revision as of 19:37, 15 April 2015
Line 101:		Line 101:

	\|}		\|}
		+
		+	== Related Videos ==
		+
		+	{{#ev:youtube\|V758Lz_MuEg\|280\|center\|COUNT}}

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

← Older revision		Revision as of 14:32, 6 November 2013
Line 18:		Line 18:
	COUNT(1..100) ''returns 100'' as a result.		COUNT(1..100) ''returns 100'' as a result.

		+	COUNT(1..100,5,TRUE,"ONE") ''returns 102'' as a result. Logical value 'TRUE' is not counted.

−	~~COUNT(1..100,5,TRUE,"ONE") ''returns 102'' as a result. Logical value 'TRUE' is not counted.~~

	* The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.		* The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.