GS

How is that possible when "$AR" and ":$AR10000" are text strings?


Gord


On Wed, 10 Aug 2011 23:17:53 -0400, GS wrote:

Your formula uses relative references. Try...

{=SUM(IDIRECT("$AR"&LARGE(($AR14:$AR10000<"")*ROW (14:10000),14&":$AR10000"))}

Hi, and thanks for the response. I tried your formula, and it works,
but just like the original formula if I try adding a column the "$AR"
parts stay "$AR" and it doesn't adjust.

Well, I can't duplicate that. If I insert columns to the left of ColAR
the formula adjusts to the new position. IOW, if I insert 1 column then
$AR becomes $AS in the formula.

--
Garry