Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

COUNTA

Description: Counts the number of cells that are not empty within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array.

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

Remarks:

Example:

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

 

COUNTA(A1:A7) = 6 [the number of nonblank cells in the list above]

COUNTA(A5:A8) = 4 [the number of nonblank cells in the last 4 rows of the list]

COUNTA(A1:A7, 2) = 7 [the number of nonblank cells in the list above and the value 2]

COUNTA(A1:A7, "Two") = 7 [the number of nonblank cells in the list above and the value "Two"]

 

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