Spread 8.0 Documentation
COUNT
Support Options
Formula Reference > Built-In Functions > COUNT

Glossary Item Box

COUNT


Name

Count

Description

Returns the number of cells that contain numbers.

Syntax

COUNT(value1,value2,...)

COUNT(array)

Remarks

The arguments may be separate values or an array of values. Up to 255 arguments of individual cells may be included. This function counts the number of cells that contain numbers in the specified cell range. This function differs from COUNTA which also includes text or logical values as well as numbers.

Data Type

Accepts cell references. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

COUNT(B2,B5,B8,D5,D8)
COUNT(A1:G5)
COUNT(R6C3:R9C4,2)

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.