Difference between revisions of "Manuals/calci/COUNTA"
Jump to navigation
Jump to search
| (14 intermediate revisions by 4 users not shown) | |||
| 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. |
| − | |||
| − | *COUNTA() | ||
| − | |||
*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( | + | 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(""). | * 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. | * 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 <math>COUNTA()</math> |
| + | **Parameter are any arguments. | ||
| + | *For e.g., COUNTA(10,12,17,true,false) | ||
== Examples == | == Examples == | ||
| Line 30: | Line 31: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class="sshl_f" | Sales | | class="sshl_f" | Sales | ||
| class="sshl_f" | 4 | | class="sshl_f" | 4 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="odd" |
| class="sshl_f" | 23/8/2009 | | class="sshl_f" | 23/8/2009 | ||
| class="sshl_f" | 3 | | class="sshl_f" | 3 | ||
| Line 45: | Line 41: | ||
<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=" | + | |- class="even" |
| 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=" | + | |- class="odd" |
| class="sshl_f" | 22 | | class="sshl_f" | 22 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="even" |
| class="sshl_f" | 52.69 | | class="sshl_f" | 52.69 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| 0 | | 0 | ||
| − | |- class=" | + | |- class="odd" |
| 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=" | + | |- class="even" |
| class="sshl_f" | #NUM! | | class="sshl_f" | #NUM! | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| Line 83: | Line 79: | ||
=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. | =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 94: | 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 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
See Also
References