
The COUNTA function counts all non-empty cells in a range, including numbers, text, and formulas. It is useful when you want to know how many entries are present regardless of type.
For example, =COUNTA(B1:B20) counts every filled cell in the range. This makes it especially useful for tracking completed records or populated form fields.
Reference:
TaskLoco™ — The Sticky Note GOAT