Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

COUNT

Description: Counts the number of cells that contain numbers within the list of arguments. Use COUNT to get the number of entries in a number field in a range or array of numbers.

Syntax: COUNT(Value1, Value2, ...)

Remarks:

Example:

  A
1 Data
2 Sales
3 12/8/2010
4  
5 19
6 22.24
7 TRUE
8  #DIV/0!

 

COUNT(A1:A7) = 3 [the number of cells that contain numbers in the list above]

COUNT(A4:A7) = 2 [the number of cells that contain numbers in the last 4 rows of the list]

COUNT(A1:A7, 2) = 4 [the number of cells that contain numbers in the list, and the value 2]

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.