INDIRECT and CONCATENATE

See example sheet.

I am wanting a formula to average the column from column D through to X. The answer should be in the corresponding cells in column C.

I want D3 to dictate the size of the array in the AVERAGE formula so I can change this on the fly?

Any thoughts welcome.

Hi,

In C6 enter the following formula:

=AVERAGE(D6:INDEX(D6:X6,$D$3))
and then copy it to the other cells in column C.