Documentation/SL/How Tos/Calc: funkcija COUNTA
From Apache OpenOffice Wiki
< Documentation | SL/How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
COUNTA
Counts the non-empty values in the list of arguments.
Skladnja:
COUNTA(value1; value2; ... value30)
value1 to value30 are up to 30 values or ranges representing the values to be counted.
Primer:
COUNTA(B1:B3)
- where cells B1, B2, B3 contain 1.1, =NA(), apple returns 3, because none of the cells in B1:B3 are empty.
COUNTA(2; 4; "dog")
- returns 3, because 2, 4 and "dog" are all numbers or text.
COUNTA(D1)
- where cell D1 contains ="", returns 1, because "" is a string (although of zero length).
