How to Use the COUNTA function to count cells containing data
To count all cells that are not empty and contain data in a range or array, use the COUNTA function. Here is the syntax that is used.
COUNTA(value1, value2, …)
value1, value2, …: 1 to 30 arguments representing the values to be counted.
To count all cells containing data:
- In cells A1:A10 type any kind of data (numeric and text).
- Select cell C1 and type the following formula: =COUNTA(A1:A10).
- Press <Enter>.
The COUNTA function does not count empty cells.
This tip is compatible with Excel 97, 2000, 2003 and 2007.
- How to Use the COUNTA function to count cells containing text
- Use the COUNT function to count cells containing numeric data
- How to Use the COUNTBLANK function to count empty cells
- How to count sets of cells located in two columns in Excel
- How to Utilize Data Entry Rules to Validate data in Excel 2007
