# Manuals/calci/COUNT

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, |

=COUNT(A4:A7) |
Counts the number of cells that contain numbers in the cells A4 to A7, |

=COUNT(C5:C7) |
Counts the number of cells that contain numbers in the cells C5 to C7, |

=COUNT(D1:D4,2) |
Counts the number of cells that contain numbers in the cells D1 to D4, |

## Related Videos

## See Also

## References