Difference between revisions of "Manuals/calci/COUNT"

Latest revision as of 15:29, 7 August 2018

COUNT ()

Parameters are any values.
- COUNT(), counts how many numbers are in the list of arguments.

Description

COUNT()

Arguments can be numbers, dates or text representation of numbers.

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.

COUNT(A1:A8,7,13) returns 6 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.
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.

ZOS

The syntax is to calculate COUNT in ZOS is
- Parameters are any values.
For e.g., COUNT(10,12,18,19,20,25)
COUNT(40..55)
COUNT(120.5..150.5)

Examples

For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns.

Sales	4
23/8/2009	3
		0
22
52.69		0
1
#NUM!

=COUNT(A1:A5)	Counts the number of cells that contain numbers in the cells A1 to A5, returns 3 as a result.
=COUNT(A4:A7)	Counts the number of cells that contain numbers in the cells A4 to A7, returns 3 as a result.
=COUNT(C5:C7)	Counts the number of cells that contain numbers in the cells C5 to C7, returns 0 as a result. COUNT() ignores the empty cells.
=COUNT(D1:D4,2)	Counts the number of cells that contain numbers in the cells D1 to D4, returns 2 as a result.

References

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-=COUNT(V1, V2...)
+<div style="font-size:30px">'''COUNT () '''</div><br/>
-*Where V1, V2 ...   are the arguments
-*COUNT() returns the number of cells that contain numbers within the list of arguments.
+*Parameters are any values.
+**COUNT(), counts how many numbers are in the list of arguments.
+== Description ==
+COUNT()
 *Arguments can be numbers, dates or text representation of numbers.
 *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.
+*COUNT(A1:A8,7,13) ''returns 6'' 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.
+* 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.
-== Description ==
+==ZOS==
-COUNT(V1,V2...)
+*The syntax is to calculate COUNT in ZOS is <math>COUNT()</math>
+**Parameters  are any values.
+*For e.g., COUNT(10,12,18,19,20,25)
+*COUNT(40..55)
+*COUNT(120.5..150.5)
+== Examples ==
-Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 5'' as a result.
+For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns.
-* 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.
-<!--
-</div>
-----
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">COUNT</div></div>
-----
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
-----
-<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
-----
-<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
-----
-<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
-----
--->
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class="   " |
-<div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-| class="  " | Column1
-| class="    " | Column2
-| class="  " | Column3
-| class="  " | Column4
-|- class="odd"
-| class=" " | Row1
 | class="sshl_f" | Sales
 | class="sshl_f" | 4
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
-| class="  " | Row2
 | class="sshl_f" | 23/8/2009
 | class="sshl_f" | 3
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
-| Row3
 | class="sshl_f" |
 | class="sshl_fSelectTD SelectTD " |
 <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="sshl_f" |
+| class="sshl_f" | 0
-|- class="even"
+|- class="odd"
-| Row4
 | class="sshl_f" | 22
 | class="sshl_f" |
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
-| class=" " | Row5
 | class="sshl_f" | 52.69
 | class="sshl_f" |
 | class="sshl_f" |
 | 0
-|- class="even"
+|- class="odd"
-| class="sshl_f" | Row6
 | class="sshl_f" | 1
 | class="sshl_f  " |
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
-| class="sshl_f" | Row7
+| class="sshl_f  " | #NUM!
-| class="sshl_f  " | #DIV/0!
 | class="sshl_f" |
 | class="sshl_f" |
@@ Line 84: / Line 72: @@
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
-----
-<div id="8SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">AVEDEV (N1, N2...)</font></font> <font size="3"><font face="Times New Roman">Where N1, N 2 ...   are positive integers.</font></font> '''</font></font></div>
-----
 <div id="5SpaceContent" class="zcontent" align="left">
@@ Line 94: / Line 78: @@
 {| class="MsoNormalTable"
 | valign="top" |
-<font size="3"><font face="Times New Roman"><nowiki>=COUNT(B2:B8)</nowiki></font></font>
+=COUNT(A1:A5)
+| valign="top" |
+Counts the number of cells that contain numbers in the cells A1 to A5, ''returns 3'' as a result.
+|-
+| valign="top" |
+=COUNT(A4:A7)
 | valign="top" |
-<font size="3"><font face="Times New Roman">Counts the number of cells that contain numbers in the list above (3)</font></font>
+Counts the number of cells that contain numbers in the cells A4 to A7, ''returns 3'' as a result.
 |-
 | valign="top" |
-<font size="3"><font face="Times New Roman"><nowiki>=COUNT(B5:B8)</nowiki></font></font>
+=COUNT(C5:C7)
 | valign="top" |
-<font size="3"><font face="Times New Roman">Counts the number of cells that contain numbers in the last 4 rows of the list (3)</font></font>
+Counts the number of cells that contain numbers in the cells C5 to C7, ''returns 0'' as a result. COUNT() ignores the empty cells.
+|-
+| valign="top" |
+=COUNT(D1:D4,2)
+| valign="top" |
+Counts the number of cells that contain numbers in the cells D1 to D4, ''returns 2'' as a result.
 |}
-</div>
+== Related Videos ==
-----
+{{#ev:youtube|V758Lz_MuEg|280|center|COUNT}}
+== See Also ==
+*[[Manuals/calci/COUNTA| COUNTA]]
+*[[Manuals/calci/COUNTIF | COUNTIF]]
+==References==
+*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]
+*[http://en.wikipedia.org/wiki/Aggregate_function COUNT]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/COUNT"

Latest revision as of 15:29, 7 August 2018

Contents

Description

ZOS

Examples

Related Videos

See Also

References

Navigation menu

Search