Changes

Manuals/calci/COUNTA (view source)

2 bytes removed , 01:45, 5 October 2015

no edit summary

Line 14: Line 14:

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.

−

~~COUNT(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.

−

~~COUNT~~(1..100,5,TRUE,"ONE") ''returns 103'' as a result.

Line 30: Line 29:

==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.

*For e.g., COUNTA(10,12,17,true,false)

writer

2,661

edits