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 20:57, 1 November 2013
280 bytes added
,
20:57, 1 November 2013
no edit summary
Line 4:
Line 4:
*COUNT() returns the number of cells that contain numbers within the list of arguments.
*COUNT() returns the number of cells that contain numbers within the list of arguments.
−
*Arguments can be numbers, dates or text
representations
numbers
that are counted
.
+
*Arguments can be numbers, dates or text
representation of
numbers.
−
*Logical values
and
text
representations of numbers
are ignored.
+
*Logical values
,
text
, error values
are ignored.
== Description ==
== Description ==
+
COUNT(V1,V2...)
+
+
Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 5'' as a result.
+
+
* The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.
+
+
* Any error values, text, empty cells or logical values are not counted.
<!--
<!--
</div>
</div>
Swapna
writer
2,661
edits