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

What's your criteria for defining that as the end of the range?

You can do something like this (assuming there are no empty cells within the
rage):

=AVERAGE(INDEX(A1:A2049,MATCH(0,A1:A2049,0)):"crit eria that defines the end
of range")


--
Biff
Microsoft Excel MVP


"Tweedy" wrote in message
...
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