Difference between revisions of "Manuals/calci/COUNTA"
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 ...") |
|||
| Line 1: | Line 1: | ||
| − | + | =COUNTA (V1, V2...)= | |
| − | + | *Where V1, V2…. are arguments. | |
| − | + | *It is used to count the number of cells which contains data in a range. | |
| − | + | *It does not include empty cells but including error values and empty text. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *Empty cells and text values in the array or reference are ignored. | |
| − | + | == Description == | |
| + | COUNTA(V1,V2....) | ||
| + | <!-- | ||
</div> | </div> | ||
---- | ---- | ||
| Line 31: | Line 25: | ||
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> | <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> | ||
---- | ---- | ||
| + | --> | ||
| + | == Examples == | ||
| + | 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"> | ||
| Line 59: | Line 56: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | | class="sshl_f" | | + | | class="sshl_f" |0 |
|- class="even" | |- class="even" | ||
| Row4 | | Row4 | ||
| Line 85: | Line 82: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
| − | + | <!-- | |
<div align="left">[[Image:calci1.gif]]</div></div> | <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="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"> | ||
Revision as of 15:41, 2 November 2013
COUNTA (V1, V2...)
- Where V1, V2…. are arguments.
- It is used to count the number of cells which contains data in a range.
- It does not include empty cells but including error values and empty text.
- Empty cells and text values in the array or reference are ignored.
Description
COUNTA(V1,V2....)
Examples
For better understanding of COUNTA() function, consider the below table that contains different types of data in various columns.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Sales | 6 | ||
| Row2 | 10/10/2009 | 7 | ||
| Row3 | 0 | |||
| Row4 | 20 | |||
| Row5 | 21.52 | 0 | ||
| Row6 | TRUE | |||
| Row7 | #DIV/0! |
=COUNTA (B2:B8) is 6
=COUNTA (B1:B7, 2) is 7