Difference between revisions of "Manuals/calci/COUNTA"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">COUNTA (V1, V2...)</font></font> <font size="3"><font face="Times New ...")
 
 
(31 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<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.
  
−
<font size="3"><font face="Times New Roman">COUNTA (V1, V2...)</font></font>
+
== Description ==
 +
COUNTA()
  
−
<font size="3"><font face="Times New Roman">Where V1, V2….   are arguments.</font></font>
+
*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.
  
−
</div>
+
* 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.
−
<div id="1SpaceContent" class="zcontent" align="left">
+
* 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.
  
−
<font size="3"><font face="Times New Roman">It is to count the number of cells which contains data in a range. </font></font>
+
==ZOS==
  
−
</div>
+
*The syntax to calculate COUNTA in ZOS is <math>COUNTA()</math>
−
----
+
**Parameter are any arguments.
−
<div id="7SpaceContent" class="zcontent" align="left">
+
*For e.g., COUNTA(10,12,17,true,false)
  
−
<font size="3">·</font>        <font size="3"><font face="Times New Roman">It does not include empty cells but including error values and empty text.</font></font>
+
== Examples ==
 +
For better understanding of COUNTA() function, consider the below table that contains different types of data in various columns.
  
−
<font size="3">·</font>        <font size="3"><font face="Times New Roman">Empty cells and text values in the array or reference are ignored. </font></font>
+
<div id="2SpaceContent" class="zcontent" align="left">
  
−
</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>
 
−
----
 
−
<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="odd"
 +
| class="sshl_f" | 22
 
| class="sshl_f" |
 
| class="sshl_f" |
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | 20
 
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
−
| class="sshl_f" |
+
|- class="even"
−
|- class="odd"
+
| class="sshl_f" | 52.69
−
| class=" " | Row5
 
−
| 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" |
Line 86: Line 68:
 
|}
 
|}
  
−
<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">
  
−
<font size="3"><font face="Times New Roman"><nowiki>=COUNTA (B2:B8) is 6</nowiki></font></font>
 
  
−
<font size="3" face="Times New Roman"> </font>
+
=COUNTA(A1:A7)  : Counts the number of cells that contain numbers in the cells A1 to A7, ''returns 6'' as a result.
 +
 
  
−
<font size="3" face="Times New Roman"> </font>
+
=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.
  
−
<font size="3" face="Times New Roman"><nowiki>=COUNTA (B1:B7, 2) is 7</nowiki></font>
 
  
 +
=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 ==
 +
 
 +
*[[Manuals/calci/COUNT| COUNT]]
 +
 
 +
*[[Manuals/calci/COUNTIF | COUNTIF]]
 +
 
 +
==References==
 +
 
 +
*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]
 +
*[http://en.wikipedia.org/wiki/Aggregate_function COUNTA]
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 16: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"