writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 14:
Line 14: + − 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. Line 30:
Line 29: − +
no edit summary
COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
COUNTA(1..100,5,TRUE) ''returns 102'' as a result. Logical value 'TRUE' is also counted.
COUNTA(1..100,5,TRUE,"ONE") ''returns 103'' as a result.
==ZOS==
==ZOS==
*The syntax is to calculate COUNTA in ZOS is <math>COUNTA(v1, v2...)</math>
*The syntax to calculate COUNTA in ZOS is <math>COUNTA(v1, v2...)</math>
**<math>v1, v2...</math> are arguments.
**<math>v1, v2...</math> are arguments.
*For e.g., COUNTA(10,12,17,true,false)
*For e.g., COUNTA(10,12,17,true,false)