Prev: ISNA and ISERROR functions
Next: How do I calculate escalation rates using dates and a set value
From: LewisM on 27 May 2010 17:14
Knowing that $A:$A can be used in a worksheet function to refer to all cells
in column A. Is there a way to refer to all cells below a starting point?
(i.e., I want to CountA() all cells below my header rows). I can't just
subtract the number of header rows because the CountA() of those varies.
--
Thanks,
LewisM
From: Don Guillett on 27 May 2010 19:13

The best way to do this is to make a self adjusting defined name range
insert>name>define>name it something like colA
in the refers to box
=offset($a$1,0,0,counta($a:$a),1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"LewisM" <LewisM(a)discussions.microsoft.com> wrote in message
news:698ABE3F-74C5-48CC-B134-419D1EDEA45F(a)microsoft.com...
> Knowing that $A:$A can be used in a worksheet function to refer to all
> cells
> in column A. Is there a way to refer to all cells below a starting point?
> (i.e., I want to CountA() all cells below my header rows). I can't just
> subtract the number of header rows because the CountA() of those varies.
> --
> Thanks,
> LewisM

 | 
Pages: 1
Prev: ISNA and ISERROR functions
Next: How do I calculate escalation rates using dates and a set value