Changes
Jump to navigation
Jump to search
← 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
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