COUNT function

From Apache OpenOffice Wiki
Jump to: navigation, search



COUNT

Counts the numbers in the list of arguments, ignoring text entries.

Syntax:

COUNT(value1; value2; ... value30)

value1 to value30 are up to 30 values or ranges representing the values to be counted.

Examples:

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.

COUNT(B1:B3)

where cells B1, B2, B3 are empty, returns 0.

Issues:

  • The ODFF standard requires that text representations of numbers are NOT counted. Calc complies to text representations of numbers in cells, in contrast to Excel. However, COUNT(4; "4") will return 2, as inline strings are converted to numbers if possible. This is described in the ODFF standard (28Dec07) in section 2.2 page 35.




See Also

Personal tools
In other languages