Using the Excel COUNTA Function
SummaryThe Excel COUNTA function will return a count of cells that are not empty. Cells to be counted may contain numbers, text, logical values, errors values, and empty text ("").
Syntax=COUNTA (value1, [value2], ...)
Required. Values that you want to count.
Value 2 and subsequent values are optional. The function can accept up to 255 values.
Usage NotesCOUNTA counts the number of cells that contain text, numbers, logical values, error values, and empty text (""). The function does not count cells that are empty. The function will count hard coded values.
The function will count cells that appear to be empty, but in fact contain invisible characters or empty strings returned by another formula. To check which cells are actually blank:
1. Press Ctrl + G
2. Select "Special"
3. Select "Blanks"
4. Confirm no blank cells are found
If you only want to count cells that contain numbers, use the COUNT function.
If you only want to count cells that meet a specific criteria, use the COUNTIF or COUNTIFS function.