COUNTA
Name
Counta
Description
Returns the number of number of cells that contain numbers, text, or logical values.
Syntax
COUNTA(value1,value2,...)
COUNTA(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 non-empty cells in the specified cell range. This function differs from COUNT because it 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
COUNTA(B2,B5,B8,D5,D8)
COUNTA(A1:G5)
COUNTA(R6C3:R9C4)