The
COUNTA() function returns the total
number of entries in the
a range of arguments.
- The syntax for
the function is COUNTA (value1,value2,...value_n).
The
argument for the function "value1, value2....
value_n" can
be a series of up to 30 values, a
referenced range of cells, an array
or a named range. In addition the function
can accepts logical values when typed
in directly.
The COUNTA function checks the arguments
to see if they contain entries. If an
argument contains a recognized entry
(such as text, numeric value, logical
value or error value) it is counted and
added to the cummulative total of non
blank cells.
- For
example: COUNTA({3,"a","",6,2,FLASE,
}) = 7.
This is
beacuse there are 7 arguments
each with recognized content.
|
The text "hello",the empty text
string "", the logical value "FALSE"
, the #DIV/0 error and the number 5
are included as cell entries and counted
by the COUNTA function.
Note: If
you do not want to count
text, logical values, or
error values use the COUNT
function see [The
COUNT fucntion knowledgebase]
[How to count how often a value occures]
[How to count cells that contain numbers]
[The
COUNTBLANK function knowledgebase]
[The
COUNTIF function knowledgebase]
[The
SUM function knowledgebase]
[The
SUMIF function knowledgebase]
|
