Difference between revisions of "Manuals/calci/COUNTA"
Jump to navigation
Jump to search
| Line 41: | Line 41: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | |||
<div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div> | <div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div> | ||
| class=" " | Column1 | | class=" " | Column1 | ||
| Line 48: | Line 47: | ||
| class=" " | Column4 | | class=" " | Column4 | ||
|- class="odd" | |- class="odd" | ||
| − | |||
| class="sshl_f" | Sales | | class="sshl_f" | Sales | ||
| class="sshl_f" | 4 | | class="sshl_f" | 4 | ||
| Line 54: | Line 52: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="even" | |- class="even" | ||
| − | |||
| class="sshl_f" | 23/8/2009 | | class="sshl_f" | 23/8/2009 | ||
| class="sshl_f" | 3 | | class="sshl_f" | 3 | ||
| Line 61: | Line 58: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="odd" | |- class="odd" | ||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| Line 67: | Line 63: | ||
| class="sshl_f" |0 | | class="sshl_f" |0 | ||
|- class="even" | |- class="even" | ||
| − | |||
| class="sshl_f" | 22 | | class="sshl_f" | 22 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| Line 73: | Line 68: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="odd" | |- class="odd" | ||
| − | |||
| class="sshl_f" | 52.69 | | class="sshl_f" | 52.69 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| Line 79: | Line 73: | ||
| 0 | | 0 | ||
|- class="even" | |- class="even" | ||
| − | |||
| class="sshl_f" | TRUE | | class="sshl_f" | TRUE | ||
| class="sshl_f " | | | class="sshl_f " | | ||
| Line 85: | Line 78: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="odd" | |- class="odd" | ||
| − | |||
| class="sshl_f" | #NUM! | | class="sshl_f" | #NUM! | ||
| class="sshl_f" | | | class="sshl_f" | | ||
Revision as of 18:23, 5 November 2013
COUNTA (v1, v2...)
- Where v1, v2…. are 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.
Description
COUNTA(v1,v2....)
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.
- 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.
Examples
For better understanding of COUNTA() function, consider the below table that contains different types of data in various columns.
| Column1 | Column2 | Column3 | Column4 |
| 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.