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 17:34, 6 June 2018
43 bytes removed
,
17:34, 6 June 2018
no edit summary
Line 1:
Line 1:
−
=COUNTA (
v1, v2...
)=
+
=COUNTA ()=
−
*
Where v1, v2….
are arguments.
+
*
Parameters
are
any
arguments.
*COUNTA() returns the count of non-empty cells, and values within the list of arguments.
*COUNTA() returns the count of non-empty cells, and values within the list of arguments.
Line 8:
Line 8:
== Description ==
== Description ==
−
COUNTA(
v1,v2....
)
+
COUNTA()
Consider columns A1 to A8 contain 3 numbers. COUNTA(A1:A8) ''returns 3 '' as a result.
Consider columns A1 to A8 contain 3 numbers. COUNTA(A1:A8) ''returns 3 '' as a result.
Line 29:
Line 29:
==ZOS==
==ZOS==
−
*The syntax to calculate COUNTA in ZOS is <math>COUNTA(
v1, v2...
)</math>
+
*The syntax to calculate COUNTA in ZOS is <math>COUNTA()</math>
−
**
<math>v1, v2...</math> are
arguments.
+
**
Parameter are any
arguments.
*For e.g., COUNTA(10,12,17,true,false)
*For e.g., COUNTA(10,12,17,true,false)
Devika
writer
6,694
edits