hi,
I have 50 consecutive numbers in column A. I want to find the average of any required consecutive block, ie rows 3 to 11, or rows 8 to 51. The numbers of the start and end row are in cells D1 and E1, and change according to data on another sheet. I prefer a formula solution rather than macros, if it can be done. I am trying to understand indirect and address functions as I suspect they may be involved.
thanks

Robert