writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + Line 8:
Line 8: − + Line 29:
Line 29: − + − +
no edit summary
=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.
== 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.
==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)