Changes
Jump to navigation
Jump to search
← 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
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Community portal
Current events
Recent changes
Help
Tools
ZCubes Web Platform
Printable version