Hello,

This is no doubt a simple one for many people here....but not me.

If i want to calculate the average for cells A1:A3, i use the following simple formula in B1: =AVERAGE(A1:A3)
I want to drag down the formula and have it automatically updated, so that
B2 equals: =AVERAGE(A4:A6),
B3 equals: =AVERAGE(A7:A9)

Thanks for any assistance.

Adam