writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − *Where v1, v2 ... are the arguments.+ − + + + Line 9:
Line 11: − + Line 30:
Line 32: − + − +
no edit summary
=COUNT(v1, v2...)=
=COUNT(v1, v2...)=
<div style="font-size:30px">'''COUNT () '''</div><br/>
*COUNT() returns the number of cells that contain numbers, and also numbers within the list of arguments.
*Parameters are any values.
*COUNT(), counts how many numbers are in the list of arguments.
*Arguments can be numbers, dates or text representation of numbers.
*Arguments can be numbers, dates or text representation of numbers.
== Description ==
== Description ==
COUNT(v1,v2...)
COUNT()
Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result.
Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result.
==ZOS==
==ZOS==
*The syntax is to calculate COUNT in ZOS is <math>COUNT(v1,v2,...)</math>
*The syntax is to calculate COUNT in ZOS is <math>COUNT()</math>
**<math>v1, v2 ...</math> are the arguments.
**Parameters are any values.
*For e.g., COUNT(10,12,18,19,20,25)
*For e.g., COUNT(10,12,18,19,20,25)
*COUNT(40..55)
*COUNT(40..55)