Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/COUNT
(view source)
Revision as of 14:31, 6 November 2013
138 bytes added
,
14:31, 6 November 2013
no edit summary
Line 14:
Line 14:
COUNT(A1:A8,7,13) ''returns 6'' as a result.
COUNT(A1:A8,7,13) ''returns 6'' as a result.
+
+
COUNT(1..100) ''returns 100'' as a result.
+
+
COUNT(1..100,5,TRUE,"ONE") ''returns 102'' as a result. Logical value 'TRUE' is not counted.
* The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.
* The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.
Swapna
writer
2,661
edits