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.