What is COUNTA?
Counts non-empty cells in a range, including text, numbers, and errors. The go-to function for determining data presence.
Syntax
=COUNTA(value1, [value2], ...)
Example
Formula: =COUNTA(A1:A100)
Result: 42
How It Works
Counts all cells that contain any value - numbers, text, errors, or formulas. Empty cells are not counted. Unlike COUNT, includes text values.