Difference between revisions of "Documentation/How Tos/Calc: COUNT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(added 'issues:') |
m |
||
| Line 3: | Line 3: | ||
== COUNT == | == COUNT == | ||
Counts the numbers in the list of arguments. Text entries are ignored. | Counts the numbers in the list of arguments. Text entries are ignored. | ||
| − | |||
=== Syntax: === | === Syntax: === | ||
| Line 9: | Line 8: | ||
<tt>'''value1'''</tt> to <tt>'''value30'''</tt> are up to 30 values or ranges representing the values to be counted. | <tt>'''value1'''</tt> to <tt>'''value30'''</tt> are up to 30 values or ranges representing the values to be counted. | ||
| − | |||
=== Example: === | === Example: === | ||
| Line 18: | Line 16: | ||
<tt>'''COUNT(B1:B3)'''</tt> | <tt>'''COUNT(B1:B3)'''</tt> | ||
: where cells <tt>'''B1'''</tt>, <tt>'''B2'''</tt>, <tt>'''B3'''</tt> contain <tt>'''1.1'''</tt>, <tt>'''2.2'''</tt>, and <tt>'''apple'''</tt> returns <tt>'''2'''</tt>. | : where cells <tt>'''B1'''</tt>, <tt>'''B2'''</tt>, <tt>'''B3'''</tt> contain <tt>'''1.1'''</tt>, <tt>'''2.2'''</tt>, and <tt>'''apple'''</tt> returns <tt>'''2'''</tt>. | ||
| − | |||
=== See also: === | === See also: === | ||
| Line 25: | Line 22: | ||
'''[[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]]''', | '''[[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]]''', | ||
'''[[Documentation/How_Tos/Calc: SUM function|SUM]]''' | '''[[Documentation/How_Tos/Calc: SUM function|SUM]]''' | ||
| − | |||
===Issues: === | ===Issues: === | ||
Revision as of 13:02, 19 January 2008
COUNT
Counts the numbers in the list of arguments. Text entries are ignored.
Syntax:
COUNT(value1; value2; ... value30)
value1 to value30 are up to 30 values or ranges representing the values to be counted.
Example:
COUNT(2; 4; 6; "eight")
- returns 3, because 2, 4 and 6 are numbers ("eight" is text).
COUNT(B1:B3)
- where cells B1, B2, B3 contain 1.1, 2.2, and apple returns 2.
See also:
COUNTA, COUNTIF, COUNTBLANK, SUM
Issues:
- The draft ODFF standard requires error values to be ignored, not propagated as in Calc. See issue 51068.
- The draft ODFF standard requires that text representations of numbers are NOT counted; Calc complies, in apparent contrast to Excel.
