Hi all,

A simple question. COUNTA($A:$A) gives me the right number of non-blank
cells in Column A. But, COUNTA(COLUMN(A1)) always seems to give me 1...

I don't want to hard-code "$A:$A", so want to replace it with something more
flexible. What formula should I use to achieve "$A:$A"?

Cheers, thanks for your time.
---
Tetsuya Oguma, Singapore