COUNTA

Used only in ReliaSoft Workbooks

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

• Value1, Value2, ... are 1 to 30 arguments representing the values you want to count.

Remarks:

• A value is any type of information, including error values and empty text (“”). A value does not include empty cells.
• If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
• If you do not need to count logical values, text, or error values, use the COUNT function.

Example:

• In the following 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"]