Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/COUNTA
(view source)
Revision as of 14:35, 6 November 2013
149 bytes added
,
14:35, 6 November 2013
no edit summary
Line 13:
Line 13:
COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
+
+
+
COUNT(1..100,5,TRUE) ''returns 102'' as a result. Logical value 'TRUE' is also counted.
+
+
COUNT(1..100,5,TRUE,"ONE") ''returns 103'' as a result.
+
* Arguments can be numbers, dates, text representation of a numbers, logical values, error values or empty text("").
* Arguments can be numbers, dates, text representation of a numbers, logical values, error values or empty text("").
Swapna
writer
2,661
edits