Hi All,

I am working on a workbook that requires prior 3 month average calculations each month for several rows. So lets say its July right now and Apr, May, June numbers are in columns A B and C. When I go into Aug, I want the forumla to calculate the average of B, C and D and so on for each new month.

Can any one help me with how I can make the inputs dynamic, so I dont have to update it each month. Assistance will be greatly appreciated.

Regards,
Sumaira

In cell D1 enter =AVERAGE(A1:C1) Then drag the formula to the right. It will update to new location (in E1 it would read =AVERAGE(B1 : D1). So at the end of July you would type your new number in over the formula (D1) and august (E1) would have the average for may, june, july.

Hope this helps

I am working on a workbook that requires prior 3 month average
calculations each month for several rows. So lets say its July right now
and Apr, May, June numbers are in columns A B and C. When I go into Aug,
I want the forumla to calculate the average of B, C and D and so on for
each new month.

If the numbers are in row 1 starting at A1, and if there are no gaps, and if future months' cells are empty, then maybe this meets the need:
=IF(COUNTA(1:1)<3,"not enough data",
AVERAGE(OFFSET(A1,0,COUNTA(1:1)-3,1,3)))