Using XL2002. . .

I have data in column A that can vary but will always be in ascending order.
(2048 time slices from data acquistions and a header row) I want to be able
to maintain the location of several points used in formulas throughout the
spreadsheet. For instance, one point I need to track is where time zero
is(or the next largest point). So if the points are shifted up or down, the
formula will automatically adjust and find time zero.

So my base static formulas are as such "=AVERAGE(A775:A1275)"

I am able to find the time zero point using
=(ADDRESS(MATCH(0.0,A1:A2049,1)+1,1)) which yields "$A$775"

A similar formula gives me "$A$1275" which is the end of the range I need to
average.

Because these are literal strings they are not accepted as arguments to
AVERAGE.
What can I do to get the two strings and the ":" to fullfill the arguments
needed for AVERAGE?

Thanks for your help.


--
Ray Tweedale
All-around-nice-guy