Difference between revisions of "Manuals/calci/COUNTA"

From ZCubes Wiki
Jump to navigation Jump to search
 
(25 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
=COUNTA (v1, v2...)=
+
<div style="font-size:30px">'''COUNTA ()'''</div><br/>
−
 
+
*Parameters are any arguments.
−
*Where v1, v2….   are arguments.
+
**COUNTA(), counts how many values are in the list of arguments.  
−
 
 
−
*COUNTA() returns the count of non-empty cells, and values within the list of arguments.  
 
−
 
 
 
*Empty cells and text values in the array or reference are ignored.
 
*Empty cells and text values in the array or reference are ignored.
  
 
== Description ==
 
== Description ==
−
COUNTA(v1,v2....)
+
COUNTA()
  
−
Consider columns A1 to A8 contain 3 numbers. Then, the function 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, or error values or empty text("").
+
* 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.
  
−
* Empty cells and text values are not counted.
+
==ZOS==
  
−
* COUNT() can be used to count the number of cells of all type of values excluding logical values, text and error values.
+
*The syntax to calculate COUNTA in ZOS is <math>COUNTA()</math>
 +
**Parameter are any arguments.
 +
*For e.g., COUNTA(10,12,17,true,false)
  
−
<!--
 
−
</div>
 
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">COUNTA</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>
 
−
----
 
−
-->
 
 
== Examples ==
 
== Examples ==
 
For better understanding of COUNTA() function, consider the below table that contains different types of data in various columns.
 
For better understanding of COUNTA() function, consider the below table that contains different types of data in various columns.
 +
 
<div id="2SpaceContent" class="zcontent" align="left">
 
<div id="2SpaceContent" class="zcontent" align="left">
 +
  
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- 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" | Sales
−
| class="sshl_f" | 6
+
| class="sshl_f" | 4
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
−
|- class="even"
+
|- class="odd"
−
| class="  " | Row2
+
| class="sshl_f" | 23/8/2009
−
| class="sshl_f" | 10/10/2009
+
| class="sshl_f" | 3
−
| class="sshl_f" | 7
 
 
| class="sshl_f SelectTD SelectTD" |
 
| class="sshl_f SelectTD 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>
 
<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="odd"
+
|- class="even"
−
| Row3
 
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |0
 
| class="sshl_f" |0
−
|- class="even"
+
|- class="odd"
−
| Row4
+
| class="sshl_f" | 22
−
| class="sshl_f" | 20
 
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
−
|- class="odd"
+
|- class="even"
−
| class=" " | Row5
+
| class="sshl_f" | 52.69
−
| class="sshl_f" | 21.52
 
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| 0
 
| 0
−
|- class="even"
+
|- class="odd"
−
| class="sshl_f" | Row6
 
 
| class="sshl_f" | TRUE
 
| class="sshl_f" | TRUE
 
| class="sshl_f  " |
 
| class="sshl_f  " |
 
| class="sshl_f" |
 
| 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" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|}
 
|}
−
<!--
+
 
−
<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">
 
<div id="5SpaceContent" class="zcontent" align="left">
  
−
=COUNTA (A2:A7) : Counts the number of cells that contain numbers in the cells A2 to A7, ''returns 6'' as a result.
 
  
−
=COUNTA (B4:B7, 2) : Counts the number of cells that contain numbers in the cells B4 to B7 and number '2', ''returns 1 '' as a result.
+
=COUNTA(A1:A7)  : Counts the number of cells that contain numbers in the cells A1 to A7, ''returns 6'' as a result.
 +
 
 +
 
 +
=COUNTA(A4:A7, 2)   : Counts the number of cells that contain numbers in the cells A4 to A7 and number '2', ''returns 5'' as a result.
 +
 
  
 +
=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>
 
</div>
−
----
+
 
 +
== Related Videos==
 +
 
 +
{{#ev:youtube|Ni1GE-Cuijg|280|center|COUNTA}}
 +
 
 
== See Also ==
 
== See Also ==
  
Line 113: Line 94:
 
*[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 ]]

Latest revision as of 15:36, 7 August 2018

COUNTA ()


  • 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.

Description

COUNTA()

  • 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(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.

ZOS

  • The syntax to calculate COUNTA in ZOS is
    • Parameter are any arguments.
  • For e.g., COUNTA(10,12,17,true,false)

Examples

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


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


=COUNTA(A1:A7) : Counts the number of cells that contain numbers in the cells A1 to A7, returns 6 as a result.


=COUNTA(A4:A7, 2) : Counts the number of cells that contain numbers in the cells A4 to A7 and number '2', returns 5 as a result.


=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.

Related Videos

COUNTA

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/COUNTA&oldid=210921"