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
Bookmarks