Hi

Please see this imageFormula question.png

In cell H1 I would like to use the subtotal formula to calculate the average of all values ranging from the Letter/Number that I typed in cell G1, so in this case A17:A1000.

Is there an easy way of doing this without having to type the A17 manually into the H1 formula?

Thanks
Marco