variable reference ranges

[Guest]

Hi - I want to write a formulae where the reference range is variable. For
example, =average(c3:c(3+variable number)). I would really like to do this
by referencing another cell for the variable number. Is this possible, I
have tried a number of approaches but am getting no joy.
Thanks
SC.

 

[Guest]

=AVERAGE(C3:INDEX(C:C, 3+C1))

where C1 contains your variable number.

 

[Guest]

Awesome!

=AVERAGE(C3:INDEX(C:C, 3+C1))

where C1 contains your variable number.