JimS formulated on Wednesday :
I have the following formula in cell AR12:
{=SUM(INDIRECT("ar"&LARGE((AR14:AR10000<"")*ROW(1 4:10000),14)&":ar10000"))}
It works exactly as I would like, except for one thing. When I insert
a new column I have to manually change the "ar" and the ":ar10000"
parts of the formula to "as" and ":as10000" to reflect the new column.
Is there a way to have this change automatically when I add a new
column so that I don't have to do it manually?
Thanks
Your formula uses relative references. Try...
{=SUM(IDIRECT("$AR"&LARGE(($AR14:$AR10000<"")*ROW (14:10000),14&":$AR10000"))}
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc