Data Selection and Averaging

[tbraddy]

I have some data that is listed in the lower portion of a worksheet
(rows 201+) and want to grab it based on user input into a cell. I
also want to calculate an average of that data.

ie
Value
Start 30 lookup value for 30
End 60 lookup value for 60
Average calculate average for 30-60

I could just do it =B230 =B260 =average(B230:B260), but having it
update would be much easier
I can do a lookup on the Start and End data, but the average is not
as
easy.

Is there a way to say =B(200 + value of Start), =B(200+End),
=average(B(200+start):B200+end))?

Thanks Todd

[roth...@gmail.com]

Start 30 =offset($b$200,30,)
End 60 =offset($b$200,60,)
Average =average(offset($b$200,30,,60-30))

Of course you may replace the 30 & 60 with cell references that
contain those values. I would suggest you readup on the offset
function. It is quite possibly one of the most powerful and flexible
excel functions.