variable reference ranges
 

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.

variable reference ranges
 

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

where C1 contains your variable number.

"SC" wrote:

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.

variable reference ranges
 

Awesome!

"JMB" wrote:

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

where C1 contains your variable number.

"SC" wrote:

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.