How to express $A:$A with formula

[Tetsuya Oguma]

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.

 

[Myrna Larson]

It's COLUMNS (plural), not COLUMN. Look up the difference in Help.

On Wed, 15 Dec 2004 17:53:02 -0800, "Tetsuya Oguma" <Tetsuya