Manuals/calci/COUNT

From ZCubes Wiki
Jump to navigation Jump to search
COUNT ()


  • Parameters are any values.
    • COUNT(), counts how many numbers are in the list of arguments.

Description

COUNT()

  • Arguments can be numbers, dates or text representation of numbers.
  • Logical values, text, error values are ignored.
  • Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) returns 4 as a result.
  • COUNT(A1:A8,7,13) returns 6 as a result.
  • COUNT(1..100) returns 100 as a result.
  • COUNT(1..100,5,TRUE,"ONE") returns 102 as a result. Logical value 'TRUE' is not counted.
  • The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.
  • Any error values, text, empty cells or logical values are not counted.
  • COUNTA() can be used to count the number of cells with empty text("") or error values.
  • COUNTIF() can be used to count the number of cells that satisfy the given criteria.

ZOS

  • The syntax is to calculate COUNT in ZOS is
    • Parameters  are any values.
  • For e.g., COUNT(10,12,18,19,20,25)
  • COUNT(40..55)
  • COUNT(120.5..150.5)

Examples

For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns.


Sales 4
23/8/2009 3
0
22
52.69 0
1
#NUM!

=COUNT(A1:A5)

Counts the number of cells that contain numbers in the cells A1 to A5, returns 3 as a result.

=COUNT(A4:A7)

Counts the number of cells that contain numbers in the cells A4 to A7, returns 3 as a result.

=COUNT(C5:C7)

Counts the number of cells that contain numbers in the cells C5 to C7, returns 0 as a result. COUNT() ignores the empty cells.

=COUNT(D1:D4,2)

Counts the number of cells that contain numbers in the cells D1 to D4, returns 2 as a result.

Related Videos

COUNT

See Also

References