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.
|