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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=560642