The
COUNT() function returns the total
number of recognized values in the
range of arguments.
- The syntax for
the function is COUNT (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 COUNT
function checks the arguments
to see if they contain entries. If an
argument contains a recognized numeric
entry (or direct logical entry) it is
counted and added to the cummulative
total of non blank cells.
- For
example: COUNT({3,8,FALSE,6,2,0,7})
= 7.
This is
beacuse there are 7 arguments in the
each with a recognized numerical values.
|
