Difference between revisions of "Manuals/calci/COUNTA"
Jump to navigation
Jump to search
| Line 96: | Line 96: | ||
</div> | </div> | ||
---- | ---- | ||
| + | == 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] | ||
Revision as of 14:57, 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 (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.