Making inputs for average formula dynamic
 

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

Making inputs for average formula dynamic
 

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)))