Excel FunctionsLesson 78Free preview
COUNTA
This lesson is part of Excel · All levels
Summary
COUNTA is an Excel statistical function that calculates the number of cells in an empty range, including those containing text, numbers, zeros, or error values. Unlike COUNT, which only counts numbers, COUNT counts all kinds of cell contents. This function is useful for checking the data load.
Key points
- COUNTTA counts all the cells that are not empty, not just numbers
- The cell contains spaces or formulas that result in empty text remaining in the count
- Accept more than one range, for example COUNTA(A1:A10, C1:C5)
- Use COUNTBLANK if you want to count empty cells
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.